Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
nt7331
Frequent Visitor

Change data visualization when more than one object is selected

Hi,

We are trying to build out some financial reporting in PowerBI and have hit a bit of a roadblock we're not sure if there is a way to solve. We have a comparison view that has a slicer built in to compare different assets together. When we select a single asset we would like to show the value over time (filter table based on slicer and a value/return column). When multiple assets are selected we would like to show return %s instead

 

Is there any way to dynamically adjust a graph like that based on slicer selection? Something simliar to what we want to do can be seen on Yahoo finance where if you add a comparison point it switches the graph from the value of an asset to the return % of it. 

1 REPLY 1
v-yulgu-msft
Microsoft Employee
Microsoft Employee

Hi @nt7331,

 

You may need several measures to achieve such a dynamical result. One measure (measure1) calculates the returned value when a single asset is selected, another measure (measure2) calculates the percentage value.

 

Then, create an extra measure using IF condition which will be displayed in graph.

Measure=IF(COUNT(SelectTable[asset])=1,[measure1],[measure2])

 

Reference: Power BI – Using a Slicer to show different measures

 

However, if you want to change the visualization type according to slicer selection, for example, change from line chart to area chart, it is not possible.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors