Change the graph when change name in the the slicer

[DR2022]

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.

 

[v-xiaotang · Accepted 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.

[DR2022]

Thank you very much for the help!