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.
Hi everyone,
I have a table with different statistics for the previous day, where the different categories are presented as sum, avg, max and mean. For some categories the sum does not make sense, e.g. sum of the pressure during a day. So I want to hide some of the categories.
The issue is I am only able to hide one category by hiding by expression. I am clicking the relevant column, then I go to Visibility in the right pane, and choose Hidden by Expression.
=Fields!DimWell2_Level_1.Value = "Category name"
It works, but I want to do several names, but cannot find a way to do it. I have tried different Or/And, without success. Anyone got a clue?
Best regards,
Ole
Solved! Go to Solution.
I would expect Or to work like this:
=(Fields!DimWell2_Level_1.Value = "Category name 1") Or (Fields!DimWell2_Level_1.Value = "Category name 2") Or (Fields!DimWell2_Level_1.Value = "Category name 3")
I would expect Or to work like this:
=(Fields!DimWell2_Level_1.Value = "Category name 1") Or (Fields!DimWell2_Level_1.Value = "Category name 2") Or (Fields!DimWell2_Level_1.Value = "Category name 3")
That worked! I was missing the ().
Thanks alot!
Ole
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 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |