Forum Discussion
Blank columns when doing Measure Name Measure Value approach
Hi GilbertGotfried ,
Thanks for the patience
Dynamic format strings work fine when a measure is used directly in a visual. The issue appears only when the measure is wrapped inside a SWITCH (or similar) expression. In that case, Power BI evaluates the wrapper instead of the original measure, so the original format string (like $ or %) doesn’t carry through, and the wrapper’s formatting is applied.
If all measures share the same format, you can just format the wrapper measure itself. If you’re dealing with mixed formats, the recommended approach is to use Calculation Groups with SELECTEDMEASURE() and SELECTEDMEASUREFORMATSTRING() to properly preserve dynamic formatting.
Please refer to the provided documentations:
1) Dynamic format strings in DAX: https://learn.microsoft.com/en-us/dax/dynamic-format-strings
2) Calculation groups : https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups
Best Regards,
Abdul Rafi
Super UserThis happens because your MeasureSelector table is a disconnected static DATATABLE with no relationship to your Date table. The Matrix renders all column combinations from the Date table regardless of whether the measure returns a value.
You could add a visual-level filter using this measure:
Has Value =
IF (
NOT ISBLANK ( [Selected Measure Value] ),
1
)Set the visual-level filter on the Columns field: Has Value is 1.
If I filter to 0, it drops all data
If I filter to 1, it does nothing
