Reply
KaiPonte
Helper I
Helper I
Partially syndicated - Outbound

How to filter on data field?

I'm sorry if this question is already answered.  I did search and only found one item, which doesn't have an answer - publish to web but missing filters? - Microsoft Fabric Community

 

We are an elecitons office. I want to do an audit report showing the users in our system, their permissions, and last time they logged in.  We have a production, training, UAT, and QA environments, all in the same database. This database is from our vendor and the same structure is used by all their clients, so we have no chance to change them. 

 

In the desktop version, I can filter my report based on the environment, which is a data field.  

 

Screenshot 2023-11-17 131851.png

 

This report will be published to our web portal. How do I do this on the web? Do I need to make different queries for the different environments?user audit powerbi.png

5 REPLIES 5
KaiPonte
Helper I
Helper I

Syndicated - Outbound

Thank you all!  I think I got it. I was able to move the slicer to the left of the screen outside the main data area.

 

Screenshot 2023-11-28 091233.png

KaiPonte
Helper I
Helper I

Syndicated - Outbound

thank you. I'd like the web version to have the same slicer or a drop down to allow for the selection on the web page.

 

Is that doable?

KaiPonte
Helper I
Helper I

Syndicated - Outbound

Hi, thank you for answering.  I want the web version to have the slicer option so I can choose.  I see if I create a slicer on the desktop, it appears on teh web. However, it is prominent on the page. Any way to minimize it or make it into a drop down?

 

Screenshot 2023-11-17 135937.png

Syndicated - Outbound

 

Power5_0-1700258683391.png

 

Power5_1-1700258738296.png

Refer to the following screenshots. Once you insert the slicer in put the value of what you want to filter by inside of it. Then goi to formatting and follow the second screenshot.

Power5
Helper IV
Helper IV

Syndicated - Outbound

Please explain further. What do you mean when you publish to web portal. You want to keep the same slicer on the web version? If that is the case, just create a slicer on your desktop version before publishing.

 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)