Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slicer not working on visual

Hi all,

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

 

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

 

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

 

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!

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

  • mussaenda's avatar
    mussaenda
    Icon for Community Champion rankCommunity Champion
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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