Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visual cannot be displayed when using a slicer

Hi All

I have a Visual  that cannot be displayed when using a slicer. If i do not use a slicer the following measured will  display the filter correctly. If i use a silcer and filter a country who's currenty is USD dollars, it isual will not be displayed. I think my dax fomula might need to be change but not sure how to go about it.

Need Help

7 Replies

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    Anonymous 

    can you please share the PBIX file to re-pro the issue.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,
    For this issue, can you give us more information?

    First, where do your 'CQMS_MNC_DATA_V[CurrenCY]' column  and 'CQMS_MNC_DATA_V[TOTAL_COST]' come from? A column  calculated column or a measure  by DAX?

    Second, what fields do you use in the visual and the slicer?

    Best regards,

    Lionel Chen

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

      Sorry for the delay but was outof town. The Total cost is from my database and there is no calulations on the Total Cost. The 123COPQ_CONVERT_USD is the Dax calulated measured. From the images below when I have No slicer selected the dax measured reports its fine but when when I select a slicer, the visual cannot be displayed. They are no filters except when using the slicer on the left. I think it might be with my Dax formaula but not sure.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Any thoughts from anyone on this issue?