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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.