Forum Discussion
Helper VHow to show the columns based on Page level filter data
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.
3 Replies
- amitchandak
Super User
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/
NarukkpHi 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 knowHi 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:
Or I think you can Button and BookMark as amitchandak mentioned before.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
