Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |