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

Опубликовано: 19 Май 2023
на канале: ِAAA Excel English
1,375
34

#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:
https://drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
   / @aaaexcelenglish  
---------------------------------------------------------------------
To follow on Facebook:
  / excelispower  
---------------------------------------------------------------------
To follow on linkedIn:
  / amratef  


Смотрите видео PBI Bites | Power BI tutorial | Period/YTD button 🔳 | use a slicer to change the selected measure онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ِAAA Excel English 19 Май 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,37 раз и оно понравилось 3 людям.