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...
  • amitchandak's avatar
    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.