Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Below is an example of my table visual with Name1, Name2, Name3 columns. I would like to create a slicer with values from all 3 columns so that I can select particular name such as "C" no matter which column has it. That is, the target slicer value "C" should select 1,3,4,7,8 rows. How to do it?
Solved! Go to Solution.
Here is how to make it work, partially. Below is my DAX to create new slicertable:
However, it gives me nothing when "All" is selected or nothing is selected. My 'Name' measure is copied and modified from someone. I believe the BLANK function is the root cause. How to fix it?
you need to create a new table
User | Count |
---|---|
84 | |
81 | |
64 | |
53 | |
45 |
User | Count |
---|---|
100 | |
48 | |
41 | |
39 | |
38 |