Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
79 | |
74 | |
44 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |