Forum Discussion
Remove automatic scaling from cards with measured values
Hi all - I feel like I'm going crazy here. I have a card that displays 4 values. The values are calculated counts I created. Like many others, I am seeing automatic scaling on the cards. Each value is showing 2k instead of 1,933 or something similar. However, I seem to have no ability to change Display Units.
When I navigate to Card...Format Visual...Visual...Callout, all I see under Value is font settings. I tried searching for the Display Units setting and it seems to be under a greyed-out Category Header option. Although it is greyed-out and cannot be clicked, I managed to switch the Display Units setting to None. Then I updated the formatting of the cards to Custom...#,##0 and it still isn't working.
I have gone through several forum posts, and two guides (here and here) but still cannot figure this out. I assume it is because I am using unique measured values. How can I remove the "K" from the card?
Hi galaxyWalker
Navigate to Callout option. Select the measure you are using for the Card visual. Go to Values, there you can see 'Display Units' option where you can change it to None and you will see the full value
Last week I also has faced this situation.
https://learn.microsoft.com/en-in/power-bi/visuals/power-bi-visualization-card
3 Replies
- Shai_Karmani
Super User
Hi galaxyWalker,
The auto scaling on the new Card visual comes from the measure's format string, not from the visual formatting pane. Setting Display units inside the visual will not stick if the measure itself does not carry an explicit format.
Click the measure in the Data pane, go to the Measure tools ribbon at the top, and set Format to Whole Number (or type #,##0 in the format field). Once each of the four measures has an explicit format, the card will show 1,933 instead of 2K.
If the visual still shows the scaled value after that, remove the field from the card and drag it back in to force a refresh.
If this helped, a thumbs up and marking it as the solution would be appreciated.
Best,
Shai Karmani- galaxyWalkerNew Member
Hi Shai_Karmani thank you for the quick reply. Unfortuantely, the measure was already set to Whole Number. I deleted the card and re-added it after confirming the formatting. It still shows 2k.
Sharing a screenshot. This is what you meant, right?
Edit to add: if I switch to a table, it shows the full number as expected. Not sure if that's relevant
- krishnakanth240
Super User
Hi galaxyWalker
Navigate to Callout option. Select the measure you are using for the Card visual. Go to Values, there you can see 'Display Units' option where you can change it to None and you will see the full value
Last week I also has faced this situation.
https://learn.microsoft.com/en-in/power-bi/visuals/power-bi-visualization-card