Forum Discussion
Solved
How to display different measures using a selector
Hi. I could not find the answer to this in other places, so I'll ask it here. I would like to create a selector that will render different measures on the same chart. For instance, I have a...
I've managed to acheive this using a measure table.
Download the following PBIX file
https://1drv.ms/u/s!AtDlC2rep7a-jkiRG_LyHcv0RSXI
You'll notice on the 2nd page called 'All Sorts' you can choose different Measure names from the box in the top left and it works.
I create a static table called [Dynamic] that carries measures and then reference them in a calculated measure on the fly
Hi,
An addtional issue I have is that the 2 measures I am toggling need to display in different formats. 1 to 1 decimal place and the other to 4 decimal places. This solution works for me apart from being able to dynamically be able to set the format of the measure returned.
Does anyone know if this is possible?,
Thanks in advance for your help,
Cheers,
Jack
Google: “Dax format”