Forum Discussion

Seer_Bug's avatar
Seer_Bug
Icon for Helper I rankHelper I
4 years ago

Need help : Table with dynamic attributes and measures

Hi Team, Looking for an output like below. In this table dimension and measures both are dynamic and i want to be able to select and display multiple dimension and multiple measures. After trying fo...
Need Help
Show and Tell
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Seer_Bug , For measure slicer we can use measure slicer (dax of calculation group)

 

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME

 

 

Axis Slicer
Three approch from Guyinacube https://www.youtube.com/watch?v=dYmzb5UMkXw
Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

Seer_Bug's avatar
Seer_Bug
Icon for Helper I rankHelper I
4 years ago

For measure slicer - i tried most videos on youtube , however those only allow me to select one measure at a time. in your video for example , i can only display MTD or YTD. What i am looking for is - to display MTD and YTD or 2 or 3 things together.