How to show the columns based on Page level filter data

[Narukkp]

Hi Team,

I have 3 page level filters (MonthYear,Week,Day) in my report . Now my requirement is if I am seleing any data on MonthYear in page level filter then I need to show Week as column in my visual , if I am selecting any data on Week at page level filter then I need to show Day as a column in my visual and if not selecting anything then I need to show default as MonthYear filed.

Could you please let me know if anyone having idea.

[amitchandak]

@Narukkp , changing a column based on slicer and filter is a bit difficult. And the way you want, I doubt that

You need to explore Bookmarks, Unpivot columns

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/

[Narukkp]

Hi @amitchandak ,
In my requirent y-axis,legend both are dynamic and i am able to achive this because these two are slicer selection but  X-axis case based on Page level filter we need to show the columns.

Any one having idea please let me know

[Anonymous]

Hi @Narukkp 

I think you want to create a visual with dynamic X axis in your report. When you select MonthYear, X axis will show week and when you select MonthYear and Week, X aixs will show Day.

Please refer to below post with similar requirement like yours.

For reference: 

Dynamic change in X Axis

Or I think you can Button and BookMark as  amitchandak mentioned before.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.