Format slicer (item size, number of columns and rows)

[Anonymous]

I have a horizontal slicer and would like to format the sixe of the items (not the text) and control how many rows and columns to display as you can do in excel. Is that possible?

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use the custom visual : chiclet slicer  https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380756?tab=overview

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

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

Appreciate your Kudos.

[Anonymous]

I would like to set number of columns and the size of the items (data cells) similar to excel (example below)

[amitchandak]

@Anonymous , I doubt there is an explicit option for that. With Orientation has horizontal and with bit of adjustment, you can get that

Refer: https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive