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.
Hi,
I´m trying to change the axis of a line visual with kind of a dynamic column which is selectable through a slicer by users.
The dax formula looks like this:
Hi @Marko33 ,
Looking at your needs, I think the following similar solutions seem to be able to help you. If there is still a problem, please point it out and I will answer it for you.
Solved: Dynamic change in X Axis - Microsoft Power BI Community
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the fast answer! Is there any explanation why this approach with selected value doesn´t work with axis but is does for other measures?
Thanks,
Marko
@Marko33 , for that you need to use bookmarks, Unpivot column.
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
There is a different option in direct query
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |