Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
andrewlxwl
New Member

Card Visual not change

Dear experts, 

 

I've built a pie chart to show orders per supplier and a card to display the number of orders. They work pretty well. When clicking each supplier, the value on the card charges accordingly.

 

However, when I wanted to add another card to show the percentage of the total, it didn't work. The data I put in the field is Count(distinct) of Order# and show the value as percentage of grand total. Initially it displays 100%. But it doesn't change as I click each supplier. 

 

Can you help to let me know how to fix it?

 

Thanks 

Andrew

1 REPLY 1
isjoycewang
Super User
Super User

Hi @andrewlxwl ,

 

Demo file attached.

Please try below formula in your card:

Count Grand Total = 
DIVIDE( CALCULATE( DISTINCTCOUNT('Table'[Order#])), CALCULATE(DISTINCTCOUNT('Table'[Order#]),ALL('Table')))

 

isjoycewang_0-1701249134001.png

 

Best Regards,

Joyce

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors