Interactivity Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/interactivity/ 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 Interactivity Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/interactivity/ 32 32 Present Power BI Reports in PowerPoint https://www.xelplus.com/power-bi-in-powerpoint/ Thu, 14 Jul 2022 08:00:00 +0000 https://www.xelplus.com/?p=9075 With the new Power BI integration for PowerPoint, you get to embed your live Power BI dashboard in your PowerPoint presentation. The process is smooth. Check it out in this complete tutorial.

The post Present Power BI Reports in PowerPoint appeared first on Xelplus - Leila Gharani.

]]> 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.

]]> How to Use Radio Buttons in Excel to Create Interactive Dashboards https://www.xelplus.com/excel-dashboards-with-radio-buttons/ Thu, 17 Jun 2021 08:00:00 +0000 https://www.xelplus.com/?p=9999 Quickly learn how to add option buttons (radio buttons) to your files to create interactive Excel Dashboards and dynamic charts. It's really easy once you learn this one trick!

The post How to Use Radio Buttons in Excel to Create Interactive Dashboards appeared first on Xelplus - Leila Gharani.

]]> Excel Dynamic Map with Drop-Down https://www.xelplus.com/dynamic-map-chart-with-drop-down/ Sun, 28 Jan 2018 21:41:00 +0000 https://www.xelplus.com/?p=11145 In case you're interested to visualize a KPI on a customized map in Excel which works on any version of Excel, then this tutorial is for you. I show you in easy steps how to find the right map and how to set it up properly.

The post Excel Dynamic Map with Drop-Down appeared first on Xelplus - Leila Gharani.

]]> Excel Dynamic Chart with Drop-Down https://www.xelplus.com/excel-dynamic-chart-with-drop-down/ Mon, 11 Dec 2017 07:36:00 +0000 https://www.xelplus.com/?p=11238 With these simple steps you can easily create an interactive chart in Excel which will for sure impress your team. Once you learn the basics for dynamic chart ranges, you can create any dynamic graph you need in Excel.

The post Excel Dynamic Chart with Drop-Down appeared first on Xelplus - Leila Gharani.

]]> Optimized Excel Line Charts: Prevent Drop to Zero https://www.xelplus.com/excel-line-charts-prevent-drop-to-zero-dynamic-legend/ Fri, 01 Dec 2017 06:50:00 +0000 https://www.xelplus.com/?p=11245 Learn how to create dynamic line charts and avoid common problems, such as line series dropping to zero and positioning the legend at the end of the line series.

The post Optimized Excel Line Charts: Prevent Drop to Zero appeared first on Xelplus - Leila Gharani.

]]>