The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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