Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
rrrrvi
Frequent Visitor

Show columns based on values

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. 

 

BranchBranch1 Branch 2Branch 3 Branch1_1Branch2_2Branch3_3Branch1_4Branch2_5Branch3_6
Metric 1         
Metric 2         
MOMJan Jan JanFeb Feb FebMar MarMar

 

If a user select Jan from the slicer, only Jan stats are displayed. 

 

BranchBranch1Branch2Branch3
Metric1   
Metric2   
MOMJan JanJan

 

 

3 REPLIES 3
rrrrvi
Frequent Visitor

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
rrrrvi
Frequent Visitor

Bumping for more visibility !

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.