cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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

Accepted Solutions
Highlighted
Helper V
Helper V

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
Highlighted
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!

Highlighted

@amitchandak 

 

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

 

No filtering is going on.

Highlighted

Anyone have any ideas on what may be going on?

Highlighted

@amitchandak

 

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

 

Thanks! 

Highlighted

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.

Highlighted
Helper V
Helper V

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors