Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using visual to filter data for slicers

Hello there,   I have a page with a treemap visual, a bar chart visual, some cards with numbers, and some slicers on top of them. The treemap visual can be used as a filter to filter data for the b...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Let's call values you select in Treemap = ValueA, values you select in SlicerA = ValueA and values you select in SlicerB = ValueB.

    Treemap won't crossfilter SlicerB like SlicerA. So though you select in Treemap, there may still exist ValueBs not in the value you select in treemap.

    I build a sample to have a test.

    I select A in treemap and select d in Slicer B, however there is no d in A, so card visual shows blank.

    If you want to show a warning message, you may build a measure.

    M.Value = IF(SUM('Table'[value])=BLANK(),"warning message",SUM('Table'[value]))

    Result:

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It's the issue with blank values. I kind of found a solution by placing a warning message there when there is a blank value. Nothing else seems to work.

Thanks

Yong

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous 

    Let's call values you select in Treemap = ValueA, values you select in SlicerA = ValueA and values you select in SlicerB = ValueB.

    Treemap won't crossfilter SlicerB like SlicerA. So though you select in Treemap, there may still exist ValueBs not in the value you select in treemap.

    I build a sample to have a test.

    I select A in treemap and select d in Slicer B, however there is no d in A, so card visual shows blank.

    If you want to show a warning message, you may build a measure.

    M.Value = IF(SUM('Table'[value])=BLANK(),"warning message",SUM('Table'[value]))

    Result:

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Rico

      That was exactly the issue and also the solution i found in the end.

      thank you

      Yong