Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
79 | |
67 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |