PBI Bites | Power BI tutorial | Period/YTD button 🔳 | use a slicer to change the selected measure

#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

[@roywilson9580]

Thanks for the interesting video. I find Power BI much better for visualising data than Excel as it has many more visualisation options.

[@aaaexcelenglish]

My pleasure Roy, totally agree, power bi is much better for visualizing days

[@cheikhhakim5864]

thank you very interesting

[@aaaexcelenglish]

Most welcome

[@cheikhhakim5864]

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

[@aaaexcelenglish]

I would do so using power query, would be much easuer than DAX