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

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.

Reply
AlainD
Frequent Visitor

Pie Chart showing percentage when filtered only not when filtering on date

Dear All,

 

Currently i am trying to install a Pie Chart which i can filter to show different definitions. 

When i filter on Destination it shows me the total of that specific destination

However when I filter on Date, it shows me like below.

 

And i need it to show as if that specific date was 100%

Also my model page is completely empty except 1 column.

 

So i just dont understand.

 

image.png

 

Can anybody please assist?

 

 
1 ACCEPTED SOLUTION
tex628
Community Champion
Community Champion

Hello,

Your dates aren't currently a slicer visual but a table visual. Selecting in a table does not use the same logic as selecting in a slicer. 

Take a look:
Selecting in a table doesn't filter, just highlight.Selecting in a table doesn't filter, just highlight.

----

Convert the table to a slicer and it should workConvert the table to a slicer and it should work
---


Connect on LinkedIn

View solution in original post

1 REPLY 1
tex628
Community Champion
Community Champion

Hello,

Your dates aren't currently a slicer visual but a table visual. Selecting in a table does not use the same logic as selecting in a slicer. 

Take a look:
Selecting in a table doesn't filter, just highlight.Selecting in a table doesn't filter, just highlight.

----

Convert the table to a slicer and it should workConvert the table to a slicer and it should work
---


Connect on LinkedIn

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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