Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
HI,
I have a value in my query called input user.
Some of these users are internal and some are external. They are stored together in the database.
In power BI im trying to figure out how to split these out into two slicers. So my end users can pick from either list and get what they want. I can't seem to be able to filter them out so that when u filter one it doesn't effec the other.
I added the same column in my query but that didn't work
How can I split out the same value into tow different slicers?
The easiest way to do this although you probably may not like it is with the Hierarchy Slicer
Where you can open either Internal or External and select!
Give it a try - otherwise you'll need to create another table - Slicer Table
Here are the steps to creating the Slicer Table
and the result...
You can also probably duplicate the Columns User Name and User Type in your table and then...
Hope this helps.
Good Luck!
Hi Sean,
When I get to step two I see:
Hi Sean,
I followed your steps-I think the disconnect (my fault) is that the internal user list and my external list are the same users.
I need to manully define our internal users from a list, then the rest are all external.
Will your method of using the split table still work - maybe I'm missing somthineg
Maybe try adding the column twice to your query.
The SQL might look like SELECT inputuser AS ExternalUser, inputuser AS InternalUser ........
Then you can two columns in your table that you can link to individual slicers.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |