Forum Discussion
Post PartisanCurrency visual AND Whole Number visual on same sheet
Hi, I need to make a Finance sheet that has numerical as well as currency data.
I changed the format to currency which has changed every visual to £.
How do I make the Voids be a whole number as 500 instead of £500, please?
Hi RichOB
If the goal is to represent the same measure in different units you can duplicate it and format differently every version of this measure.
For example, the "origin" measure is :
total_ = sum('Table 1'[value])format it as a whole numberAnd duplicate measure is :
total_$ = [total_]it has been formatted as a currencyResult: 2 cards with the same referenced measure, in a different format
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
3 Replies
- Ritaf1983
Super User
Hi RichOB
If the goal is to represent the same measure in different units you can duplicate it and format differently every version of this measure.
For example, the "origin" measure is :
total_ = sum('Table 1'[value])format it as a whole numberAnd duplicate measure is :
total_$ = [total_]it has been formatted as a currencyResult: 2 cards with the same referenced measure, in a different format
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other
members find it more quickly
RichOBHi Ritaf1983 , thanks for replying!
When I go to the Column Tools and change it to currency, it changes the Voids (and everything on that sheet) to currency £500. How would I isolate individually so the Restricted visual is currency and the Voids is a whole number? I can't see the Measure Tools in the row of options either.
Thanks