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
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.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors