Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to be able to filter or use a slicer that when I select one or more of the 4 columns listed below that it will show the data by using an "or". For example if I selected RX 2 & RX 3, that it will show me all of the data without a Null value for either column so that the expected results would show data for rows 2, 3, and 4
# | RX 1 | RX 2 | RX 3 | RX 4 |
1 | True | True | ||
2 | True | |||
3 | True | True | ||
4 | True | True |
Solved! Go to Solution.
Thank you everyone. I ended up copying the table and then deleted all of the columns that I didn't need and kept the ID, Claim Number and the 4 Rx columns. I then highlighed those 4 Rx columns in Power Query Editor and right click an selected the "Unpivot Columns". I then created a small table with the 4 Rx values to use in the Slicer. I then created the relationships to the correct table and was able to create a Slicer that the user could use to select the data.
Hi @jmerdman ,
According to your description, you can refer to the following blog entry to create a dynamic selector for column selection
Then use the CONCATENATEX function to combine the contents of the selected column fields. Something like the following:
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jmerdman , for Or you needed independent tables for slicer values
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Thank you everyone. I ended up copying the table and then deleted all of the columns that I didn't need and kept the ID, Claim Number and the 4 Rx columns. I then highlighed those 4 Rx columns in Power Query Editor and right click an selected the "Unpivot Columns". I then created a small table with the 4 Rx values to use in the Slicer. I then created the relationships to the correct table and was able to create a Slicer that the user could use to select the data.
Hi @jmerdman ,
If it is feasible, could you provide detailed screenshots of the steps for my reference. I would appreciate it. Looking forward to your reply.😁
Best Regards,
Henry
Hi Henry,
Sorry it took me a bit to get back to this but below are the steps that I used that fixed my issue and allowed me to filter.
I was able to then add a filter from the new table and filter on the different values. Hope this helps.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |