- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Subject | Author | Posted | |
---|---|---|---|
03-07-2024 08:21 PM | |||
Anonymous
| 08-07-2024 04:03 AM | ||
07-10-2024 04:45 AM | |||
07-11-2024 07:18 AM | |||
11-13-2023 11:55 PM |
User | Count |
---|---|
141 | |
115 | |
82 | |
63 | |
48 |