cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SCTDev Regular Visitor
Regular Visitor

Warning 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 1
Community Support Team
Community Support Team

Re: Warning about DAX and Dashboard

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 350 members 3,439 guests
Please welcome our newest community members: