cancel
Showing results for 
Search instead for 
Did you mean: 

Slicer configuration change when updating information

Good afternoon.
I hope you are well and I hope you can help me. I have a fairly advanced dashboard that is powered by a SQL database. I have this group of variables as slicers (see image), with the aim of serving as filters applied to the visualizations. These slicers are found on several pages of the report (they are the same on all pages).

1.png

However, when I refresh the database with the Refresh button in Power BI, the slicers lose the display features they had configured. For example, slicers were set to "Dropdown", but after the update, they change to "List". This image is after updating the data.

2.png

It is a strange behavior and one that has never happened to me. Also, it can happen for all slicers on one page, but it can also happen to some slicers on other pages. In the next image, you can see that only the slicer setting “YEAR” changed.

3.png

It should be noted, that I have the version of Power BI with the November 2020 update.

 

I will be very grateful if you help me identify why this is happening and possible solutions.
Thanks. Greetings.

 

Status: New
Comments
Community Support

hi  @RichardFig1 

I have tested on my side, but not reproduce the issue. Version: 2.87.1061.0 64-bit (November 2020)

and here is a similar post, you may take a look:

https://community.powerbi.com/t5/Desktop/Issue-Slicer-automatically-changes-type-from-Dropdown-to-Li...

 

Regards,

Lin