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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Slicer not working on visual

Hi all,

I have a pie chart with Category: Country and Item-Country and Values: Build Up 3 Months.

blueraccoon_0-1628144516591.png

blueraccoon_1-1628144566890.pngblueraccoon_2-1628144577212.png

 

I created a slicer for Country with Fields for Country and Item-Country.

blueraccoon_3-1628144638792.png

blueraccoon_4-1628144646792.png

 

However when I select a country, the visual returns a blank.

blueraccoon_5-1628144702489.pngblueraccoon_6-1628144707225.png

 

If I select the drop down on a country and select a particular Item-Country the slicer works...

All fields in the visual and slicer are located in the same table.

Any ideas on how to fix this so that the Country slicer works?
 

Thanks guys!

4 REPLIES 4
mussaenda
Super User
Super User

Hi @Anonymous , is your filter comibg from the same table of the pie chart date that you are using?

Anonymous
Not applicable

Yes, the filter is from the same table as well.

amitchandak
Super User
Super User

@Anonymous , I tried on my system with two-column.

If I do not use the expand sign (reverse Y sign), it just shows me one value when I select a country.

 

refer

 

Screenshot 2021-08-05 13.00.44.pngScreenshot 2021-08-05 13.00.51.pngScreenshot 2021-08-05 13.01.06.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

Hi @amitchandak  thank you for your reply, however in my case the "Build Up 3 Months" is a calculated measure therefore I'm unable to put it in the field of the slicer.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.