Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a great formula that change of the measure based on the user selection
The problem is that on this formula we calculate some values as Decimal Number and 2 others as Percentage but when selecting the values that should appear in % they appears as decimal
is there anyway to solve this? that when user select X Measure the values shown as % if they are % or decimal if not
this values should be %
this values are displayed correctly
Solved! Go to Solution.
Hi @Anonymous
Have you tried using Field Parameters? https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi @Anonymous
Have you tried using Field Parameters? https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
@Anonymous
It is, you can do that using calculation groups. Take a look at this video from GIAC.
https://www.youtube.com/watch?v=vlnx7QUVYME&ab_channel=GuyinaCube
Towards the end he shows how for format the % measures correctly.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
45 | |
43 |