Using visual to filter data for slicers

[YongJiang]

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 bar chart and cards but it has no effect on the data underlying the slicers. I can get CROSSFILTER function to filter data between slicers (that is to filter data for slicer B using data in slicer A) but this does not work for the treemap visual. With CROSSFILTER function it works to change the underlying data for the other slicers if the treemap is turned into a slicer itself. But I need to keep the treemap.

Because of this, when I click a point in the treemap, I'll see changes on my bar chart and the cards, and then I keep going by selecting a value in a slicer, the bar chart and the cards can go blank, as there is no data for the selected item in the slicer.

Is there a way to make sure the page does not go blank?

Any advice is appreciated.

Yong

[amitchandak · Accepted solution]

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

Appreciate your Kudos.

[amitchandak · Accepted solution]

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

Appreciate your Kudos.

[YongJiang]

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

[v-rzhou-msft · Accepted solution]

Hi @YongJiang 

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. 

[YongJiang]

Hi Rico

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

thank you

Yong