Forum Discussion
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 t...
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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