Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table where one of the rows is the month.
Have to create a slicer , such that depending on the selected month in the slicer , the columns which have that month are displayed in the dashboard view.
Branch | Branch1 | Branch 2 | Branch 3 | Branch1_1 | Branch2_2 | Branch3_3 | Branch1_4 | Branch2_5 | Branch3_6 |
Metric 1 | |||||||||
Metric 2 | |||||||||
MOM | Jan | Jan | Jan | Feb | Feb | Feb | Mar | Mar | Mar |
If a user select Jan from the slicer, only Jan stats are displayed.
Branch | Branch1 | Branch2 | Branch3 |
Metric1 | |||
Metric2 | |||
MOM | Jan | Jan | Jan |
I was able to resolve my problem by following this link
https://blogs.perficient.com/2022/06/29/power-bi-dynamic-columns-in-a-table/
HI @rrrrvi,
I'm glad to hear you found the resolution and thanks for sharing the link here, they will help other who has similar requirements.
Regards,
Xiaoxin Sheng
Bumping for more visibility !