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 have a slicer with 4 items. Eg: x,y,z,and o.
Requirements:
How can I accomplish this?
Solved! Go to Solution.
Hi @Anonymous ,
You can use visual level filter:
Measure = IF(ISFILTERED(Table2[category]),IF(MAX(Table2[category])="o",1,IF(MAX(Table2[category])= MAX(Table1[Category]),1,0)),1)
Please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I can't use another table as slicer in this case. The slicer should behave normally with all other visuals except the table.
Hi @Anonymous ,
The normal solution for your case is creating a disconnected table with these slicer value as mentioned by amitchandak.
The detailed solution depends on your data model. Would you please show us sample pbix file, Then there may be a solution to your case.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
You can use visual level filter:
Measure = IF(ISFILTERED(Table2[category]),IF(MAX(Table2[category])="o",1,IF(MAX(Table2[category])= MAX(Table1[Category]),1,0)),1)
Please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks.. It worked
@Anonymous , prefer an independent table for these values. Then you can have a measure like
measure =
var _val = selectedvalue(Dim[Col])
return
if(_val = "o", calculate(sum(Table[Value]), filter(Table, Table[Col] <> _val)) , calculate(sum(Table[Value]), filter(Table, Table[Col] = _val)))
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |