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.
Dear All,
When applying a filter I want the result to always show one value, as well as the selected option.
The fields are as below:
0
1
2
3
I want the filter to only show options 1, 2 & 3.
When a user selects 1, 2 or 3 I want all items connected with value 0 to also remain in the visualized results.
Is there a way I can obtain this result?
Thank you
gianmarco
Solved! Go to Solution.
Hi @gianmarco ,
Based on your description, I have created a simple sample:
Please try:
First add a new table for slicer:
For Slicer =
var _a = FILTER(SUMMARIZE('Table',[Column1]),[Column1]<>0)
var _b = CROSSJOIN({0},_a)
var _c = ADDCOLUMNS(_a,"Value",[Column1])
return UNION(_b,_c)
Output:
Then create a relationship between the two tables:
Create a slicer:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gianmarco ,
Based on your description, I have created a simple sample:
Please try:
First add a new table for slicer:
For Slicer =
var _a = FILTER(SUMMARIZE('Table',[Column1]),[Column1]<>0)
var _b = CROSSJOIN({0},_a)
var _c = ADDCOLUMNS(_a,"Value",[Column1])
return UNION(_b,_c)
Output:
Then create a relationship between the two tables:
Create a slicer:
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |