Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Niels_T
Post Patron
Post Patron

Slicers in Power BI Desktop won't display properly in Power BI web app

I have made a report with a slicer with 3 options (3 brands) to filter data in the report. Everything works fine within Power BI desktop. It filters data and does it's job.

 

Niels_T_2-1609147423547.png => This is Power BI Desktop

 

Once I upload to Power BI web app to show my report to the consumers, I only get to see 1 option (1 brand).

 

Niels_T_1-1609147397859.png => This is Power BI web app after publishing from desktop 

 

 

This is so strange because everything works and shows perfectly within Power BI desktop.

1 ACCEPTED SOLUTION
aj1973
Community Champion
Community Champion

Yes do that through recreation. Don't duplicate the whole page. it might not work.

 

Let me know how it works out for you.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

7 REPLIES 7
aj1973
Community Champion
Community Champion

Hi @Niels_T 

Did you implement a RLS in the desktop?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 

 

No there is no RLS in the desktop.

aj1973
Community Champion
Community Champion

Create the same visual in another page of the report and Publish it. see if the problem still the same with it. If not then delete your previous visual and recreate it

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 

 

Strangely enough, when I add the slicer in another page of the report and publish it, it does show me the 3 options.

 

I also just added a new slicer with 3 options in my original page, but with no avail. It just shows me one option instead of the 3.

 

Niels_T_0-1609165065988.png

 

Niels_T_1-1609165127690.png

 

 

I have a feeling recreating the whole page would be easier. 

aj1973
Community Champion
Community Champion

Yes do that through recreation. Don't duplicate the whole page. it might not work.

 

Let me know how it works out for you.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 

 

It's working now! I have no idea what the problem could have been.

 

Thank you for trying to help me 🙂

aj1973
Community Champion
Community Champion

@Niels_T 

Please mark this issue as solved for the community

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors