slicer single select

[CahabaData]

bar graph: X axis are customers. Y axis is $$.  Slicer is Years.

Slicer; Selection Controls - 'Single Slicer' turned On behaves identical to turned Off - except for the check box icon.

[Select All is turned off]

when Single Select is turned On - one can check multiple years and the bar graph aggregates (gets taller) and the check box (in the slicer) is just filled in black

when it's turned Off - one can check multiple years and the bar graph aggregates and the check box is filled in black with a check symbol.

the check box symbol is the only behavioral difference between On and Off

I was thinking when turned On single select that if you choose 2017 then it unchooses 2016 so only 1 year at a time can be selected.

[Anonymous]

Hi @CahabaData, when you turn Single Select "On", then you should only be able to select one value at a time. If you hold control and click, it will still let you select multiple.

Turning Single Select "Off" will allow to to select multiple values without holding control.

Are you seeing different behavior?

[CahabaData]

Definitely seeing behavior as originally posted.  The Single Select ON is allowing multiple selections which aggregate the values displayed.

I have moved the pbix file to another PBI Desktop installation - same behavior.  Both are this March PBI installs.

So I wonder if it is the dataset itself - though I can't figure out why.  There is 1 bar graph and 1 slicer on the report page.  The slicer is year and is using the Date field from the same table as the bar graph is based.

[Anonymous]

Hi @CahabaData, I'm not able to replicate this scenario. If you want to post your .pbix file I'd be happy to try and look into it further.

[CahabaData]

appreciate the offer; will see if I can de-privatize the data set