PBI Bites | Power BI tutorial | Period/YTD button 🔳 | use a slicer to change the selected measure
Vložit
- čas přidán 5. 09. 2024
- #powerbi #dax #tables
---------------------------------------------------------------------
Visit the website: www.aaa-power.net
---------------------------------------------------------------------
Sometimes you may need to use a slicer to change your measure selection. Like the case of period / year to date measures, you may need to present them on the same visual based on the user's choice.
In this case you will need to create a table with a single column to store your options values, then you can create a slicer based on this table and use SELECTEDVALUE function to capture the slicer selection. the rest will be quite easy using SWITCH function
---------------------------------------------------------------------
To download working files:
drive.google.c...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcelenglish
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on linkedIn:
/ amratef
Thanks for the interesting video. I find Power BI much better for visualising data than Excel as it has many more visualisation options.
My pleasure Roy, totally agree, power bi is much better for visualizing days
thank you very interesting
Most welcome
Please Sir can you explain how we use the dynamic segmentation to do an aged balance ( for customer) by defining rules for example (Last 30 days; Between 31 and 60 days;Between 61 and 120 days;Between 121 and 180 days....) thanks in advance
I would do so using power query, would be much easuer than DAX