Show columns based on values

Question

I have a table where one of the rows is the month.&nbsp;&nbsp;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.&nbsp;&nbsp;BranchBranch1&nbsp;Branch 2Branch 3&nbsp;Branch1_1Branch2_2Branch3_3Branch1_4Branch2_5Branch3_6Metric 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Metric 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;MOMJan&nbsp;Jan&nbsp;JanFeb&nbsp;Feb&nbsp;FebMar&nbsp;MarMar&nbsp;If a user select Jan from the slicer, only Jan stats are displayed.&nbsp;&nbsp;BranchBranch1Branch2Branch3Metric1&nbsp;&nbsp;&nbsp;Metric2&nbsp;&nbsp;&nbsp;MOMJan&nbsp;JanJan&nbsp;&nbsp;

rrrrvi · Answer

I was able to resolve my problem by following this link&nbsp;https://blogs.perficient.com/2022/06/29/power-bi-dynamic-columns-in-a-table/&nbsp;&nbsp;

rrrrvi · Answer

Bumping for more visibility !

anonymous · Answer

HI&nbsp;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

Forum Discussion

Show columns based on values

3 Replies

Related content

Change column values based on different column values

Filter a column with duplicate values based on the highest Index value

find max value based on another filtered column

Replace value based on condition from other column

Calculated column based on slicer value

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