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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
KaiPonte
Helper I
Helper I

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

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

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

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

 

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

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.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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