Forum Discussion
Bug Report - Card Visual Display Units With Measure Named "All" - Workaround Included
- 4 months ago
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.
- 4 months ago
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
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.