cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Patron
Post Patron

Measure shows value in table visual but not in card visual

Hello All,

 

I've having some trouble with a card visual that displays a (Blank) value when I highlight a particular line in a table visual. The data is there so I know the value isn't (Blank).

 

In the photo below if I highlight the first row everything works as expected. The card display shows 66.62%, which is the same value in the last column in my table.

Untitled3.png

 

But when I highlight the second row, the card displays (Blank). It should display 88.13%, which is what the table shows in the last column.

Untitled4.png

 

Does anyone know what may be going on?

 

Thanks in advance for your help!

1 ACCEPTED SOLUTION
Post Patron
Post Patron

I ended up creating a measure instead of using the column. For some reason the column was affecting the results on certain rows when highlighted. Doesn't make sense that a column in the same table would be causing the card display to show blanks.

View solution in original post

6 REPLIES 6
Post Patron
Post Patron

I ended up creating a measure instead of using the column. For some reason the column was affecting the results on certain rows when highlighted. Doesn't make sense that a column in the same table would be causing the card display to show blanks.

View solution in original post

Super User IV
Super User IV

@nleuck , can share the formula. In case you are using some row context, this can happen.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak 

 

It's a simple DIVIDE(SUM(column name), SUM(column name))

 

No filtering is going on.

Anyone have any ideas on what may be going on?

@amitchandak

 

Do you happen to have any idea what may be causing it to do that?

 

Thanks! 

Hi @nleuck ,

 

What is your data structure like?

Do the fields in the matrix table belong to the same table?

Could you please provide a mockup sample based on fake data?

It will be helpful if you can show us the exact expected result based on the tables.

 

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors