Forum Discussion
Bug Report - Card Visual Display Units With Measure Named "All" - Workaround Included
When using the card visual, if the measure is named "All" you cannot select it to change the display units off of default. Instead it will show two entries in the dropdown named "All" that behave as if it was the native PBI all option without display units as a selection. There is a workaround where you can change the name of the measure, change the display units, then change it back and the selection remains. Pretty annoying though when the team wants the displayed measure to be named "All".
Power BI has a built-in/reserved keyword or context item called "All" (related to the ALL() DAX function and the default "All" in some dropdowns/filters). When your measure is also named exactly "All", the UI gets confused and treats your measure as if it were the native "All" option in the display units dropdown. This results in:
- Two identical "All" entries appearing.
- Your actual measure's display units settings being ignored.
It's a naming collision in the visual property pane.
Confirmed Workarounds (ranked by practicality)
Best short-term workaround (the one you mentioned)
- Temporarily rename the measure to something else (e.g. "All Measure" or "Total All").
- Set the desired Display units (Thousands, Millions, etc.) and decimal places.
- Rename it back to "All". The display units setting usually sticks even after renaming back.
Use a space or special character (most people’s preferred permanent fix) Rename the measure to one of these (they look almost identical to "All" in visuals):
- "All " (All with a trailing space)
- "All." (All with a period)
- "All_" (All with underscore)
- "All-"
Most teams accept "All " because it displays cleanly as "All" on the card.
Create a duplicate measure with a different name for formatting only
daxAll Display = [All] // this one you actually use on the cardThen apply display units to "All Display" and hide the original "All" measure from the report view if you don't want it cluttering things.
Use Field formatting instead of the visual's Display units (Power BI Desktop / Service)
- Select the card visual → Format pane → Field formatting (or directly on the measure in the Fields pane).
- Sometimes this bypasses the dropdown issue.
Hope this helps. if so please mark it as a solution. Kudos are welcome.
Hi MNXDD ,
Thank you for reaching out to the Microsoft Community Forum.
Instead of using Card visual, better to use Advance card from custom visuals.
I tried to replicate with Advance card visual , it's working. It is showing the desired result.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
4 Replies
- pcoleySuper User
Power BI has a built-in/reserved keyword or context item called "All" (related to the ALL() DAX function and the default "All" in some dropdowns/filters). When your measure is also named exactly "All", the UI gets confused and treats your measure as if it were the native "All" option in the display units dropdown. This results in:
- Two identical "All" entries appearing.
- Your actual measure's display units settings being ignored.
It's a naming collision in the visual property pane.
Confirmed Workarounds (ranked by practicality)
Best short-term workaround (the one you mentioned)
- Temporarily rename the measure to something else (e.g. "All Measure" or "Total All").
- Set the desired Display units (Thousands, Millions, etc.) and decimal places.
- Rename it back to "All". The display units setting usually sticks even after renaming back.
Use a space or special character (most people’s preferred permanent fix) Rename the measure to one of these (they look almost identical to "All" in visuals):
- "All " (All with a trailing space)
- "All." (All with a period)
- "All_" (All with underscore)
- "All-"
Most teams accept "All " because it displays cleanly as "All" on the card.
Create a duplicate measure with a different name for formatting only
daxAll Display = [All] // this one you actually use on the cardThen apply display units to "All Display" and hide the original "All" measure from the report view if you don't want it cluttering things.
Use Field formatting instead of the visual's Display units (Power BI Desktop / Service)
- Select the card visual → Format pane → Field formatting (or directly on the measure in the Fields pane).
- Sometimes this bypasses the dropdown issue.
Hope this helps. if so please mark it as a solution. Kudos are welcome.
- v-dineshyaCommunity Support
Hi MNXDD ,
Thank you for reaching out to the Microsoft Community Forum.
Instead of using Card visual, better to use Advance card from custom visuals.
I tried to replicate with Advance card visual , it's working. It is showing the desired result.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
- v-dineshyaCommunity Support
Hi MNXDD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
- v-dineshyaCommunity Support
Hi @MNXDD ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh