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! How can I create measurements in DAX to change the x-axis, y-axis, and y-axis data of the line dynamically, by changing the search name in the slicer? And include changes to the color of graphics as well. Is this possible in PBI? It would be like me clicking on a name in the slicer and the column, row and color of the graph would automatically change. The image below is just an example of the graph.
Solved! Go to Solution.
Hi @DR2022
Thanks for reaching out to us.
The color can change dynamically according to the slicer. For the x-axis, it is a fixed coordinate, maybe you can limit its range through filter, so as to dynamically transform the range of coordinates. For the y-axis, it is obtained according to the value and cannot be dynamically changed according to the slicer.
Here are 2 articles for your reference, please check if they are helpful,
Dynamic dimensions in Power BI | LeanX
Power BI – How to Filter Slicers dynamically – Gilbert Quevauvilliers – BI blog (wordpress.com)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @DR2022
Thanks for reaching out to us.
The color can change dynamically according to the slicer. For the x-axis, it is a fixed coordinate, maybe you can limit its range through filter, so as to dynamically transform the range of coordinates. For the y-axis, it is obtained according to the value and cannot be dynamically changed according to the slicer.
Here are 2 articles for your reference, please check if they are helpful,
Dynamic dimensions in Power BI | LeanX
Power BI – How to Filter Slicers dynamically – Gilbert Quevauvilliers – BI blog (wordpress.com)
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for the help!
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |