cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DR2022
Regular Visitor

Change the graph when change name in the the slicer

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.

Imagem1.png

1 ACCEPTED SOLUTION
v-xiaotang
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-xiaotang
Community Support
Community Support

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!

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors