Forum Discussion
Conditional format (modeling) of number
Hi everyone.
In a report I've defined a measure as follows:
Measure = IF('TabFlag'[Flag]="Abs"; [KPI Absolute]; [KPI Percentage])And I've associated a slicer to the flag, which allows the user to choose between KPI Absolute and KPI Percentage (which are two different measures).
I want to show the measure in a bar chart, but the problem is that it's not possibile to me to give the right formatting of the number: I would like that the value of Measure is showed as a whole number if the absolute form is selected, and that the same Measure is showed as a percentage if the other option is preferred.
I've tried using the FORMAT DAX function, but it return a string, which cannot be represented in the bar chart, so it does not suit at all.
Thanks.
3 Replies
- rode
Advocate II
I've found out that the feature I'm searching for is not available in Power BI right now. But there in an idea about this.
- v-huizhn-msft
Microsoft Employee
Hi rode,
You can vote the feature and add comments in the link above. Your support will make our product better. Thanks a lot.Best Regards,
Angelia- rode
Advocate II
Already done! Thanks :)