SWITCH (DAX) Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/switch-dax/ Bestselling Excel and Power BI Courses Tue, 25 Apr 2023 14:02:30 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png SWITCH (DAX) Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/switch-dax/ 32 32 How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

]]>