Forum Discussion
Advocate IWarning about DAX and Dashboard
About a week ago a change occurred in PBI where something that was working stopped working.
I have a measure that is displayed on a card, and about a week ago the dashboard where the card is pinned started displaying:
(Blank)
The report displayed the value correctly, e.g. 5.2, but the pinned card displayed "(Blank)". It used to display the value in the dashboard until about 4/15/2017.
I found the error was in my DAX forumula for the measure. I was using FIXED to format the measure to 1 digit to the right of the decimal point but I didn't notice that FIXED returns TEXT, not a DECIMAL NUMBER. Once I changed the formula to use ROUND instead of FIXED, the value displayed correctly. My guess is the code for dashboards changed about that time and more rigidly enforced that only decimal numbers can be displayed as numbers on cards.
Mark
1 Reply
Hi SCTDev,
I'd like to suggest check the report if the card visual in report also got blank.
If this is a case, I think the issue may related to source data, please double check your datasource and share some detail contents about this issue.(e.g. datasource type, connect mode, refresh history, gateway state...)>>My guess is the code for dashboards changed about that time and more rigidly enforced that only decimal numbers can be displayed as numbers on cards.
Card visual and measure also support text and other numeric type.
Regards,
Xiaoxin Sheng
