Line and clustered column chart shouldn't show line until something selected in a slicer

[Anonymous]

I have years and months in chiclet slicer and I have Line and clustered column chart that is showing water pumpage and temperature data. Please find the below screenshot for your reference.

The default functionality for a slicer in Power BI seems to be that if nothing is selected in a slicer then summed values are showed as line in Line and clustered column chart. I don’t really need to see the temperature if there is more than one year picked. I don’t want to show the temperature (summed temperature which doesn’t really make much sense) when nothing or some years are selected.

What I would like to do is I wanted to show the temperature as a line only when one year is selected in the slicer. Is this possible?

[v-gizhi-msft]

Hi,

According to your description, i create a sample to test:

Then try to create a seperate slicer table:

SlicerTable = DISTINCT(SELECTCOLUMNS('Table',"Year",'Table'[Year]))

Then try these two measures:

Sales Sum = IF(DISTINCTCOUNT(SlicerTable[Year])=1,0,CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Year] in FILTERS(SlicerTable[Year]))))

Sales Average = IF(DISTINCTCOUNT(SlicerTable[Year])=1,CALCULATE(AVERAGE('Table'[Sales]),FILTER('Table','Table'[Year]=SELECTEDVALUE(SlicerTable[Year]))),BLANK())

When you only select one value in slicer, the visual shows:

When you select more than one value or do not select any value in slicer, the visual shows:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto

[Anonymous]

Hi Giotto,

Thank you so much for your clear explaination!

I am sory for not explaining my problem clearly. 

Please find the below dataset

What I am looking for is

When I select one value in slicer, I should see both columns and line in line and stacked column chart as shown in below screenshot

When I select more than one value or no selection I should see as below:

Please let me know if there is any way of doing this.

Thank you for your help!

Regards,

Aswini

[v-gizhi-msft · Accepted solution]

Hi,

Please check this:

pbix 

Hope this helps.

Best Regards,

Giotto

[amitchandak]

@Anonymous 

This can give idea how many values are selected. You can change action or results

Measure = if(ISFILTERED('Date'[Year]),if(COUNTROWS(ALLSELECTED('Date'[Year]))>1,"Multiple","Sigle"),"No selection")

[Anonymous]

I created a measure as you suggested.. 

Measure = if(ISFILTERED('Pumpage'[Year]),if(COUNTROWS(ALLSELECTED('Pumpage'[Year]))>1,"Multiple","Single"),"No selection")

But how to link this with Chiclet slicer and line and clustered column chart? Please let me know if you have any idea.

[Anonymous]

Thank you for your time!

I added measure to "filters on this visual" and selected Single. When I am selecting an year it is displaying "line and stacked column chart". Chart is empty when I make multiple year selection or when I don't make any selection.

What I want is when I select a single year it should display a line in "line and stacked column chart".  when I make multiple year selection or when I don't make any selection it should just display "stacked column chart" without line. Is there any way to do it?