Forum Discussion
Using visual to filter data for slicers
- 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. - Anonymous5 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.
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.
Hi Rico
That was exactly the issue and also the solution i found in the end.
thank you
Yong