slicer behavior changed? how to get the dorpdownlist?

[Willgart]

Hi,

the slicer behavior has changed, or is it because I'm now using Tabular 2017?

now when I put a number in a slicer, I dont have the choice, its a range slicer, no way to change it to a list or dropdownlist anymore !!!

I want to put my years in a horizontal mode, like I do in the past, but I cant do it anymore.

any idea?

same stuff for the dates, no options to change the behavior.

its frustrating!!!!

is it because I just upgrade from SQL 2016 to 2017? or its related to the latest release of power bi ?

[gooranga1 · Accepted solution]

Do have the Header switched on? If not switch it on temporarily then change to list.

The drop down needs to be switched to list then you can modify the orientation.

[Willgart]

thanks that's it!!!

wow

so hidden 🙂