Forum Discussion
How is the master who can do this ?
Here is DAX
Hi Jalil239
Many thanks to danextian , mianjalil239 and dharmendars007 for their prompt reply. Let me add something here.
You may not be able to do this in the default design of power bi desktop, but let's try something else:
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community
As mentioned in this post, you can turn off "Text wrap" in "Values" and "Column headers" and do this by adjusting the width.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- danextian
Super User
Hi Jalil239
Trying to hide a measure in the matrix viz hides all measures for that related column altogether.
What you are trying to achieve requires a disconnected table that contains the desired column as value placeholders and then a measure to show the desired values.Please see attached sample pbix.
- dharmendars007
Memorable Member
Hello Jalil239 ,
Please try the below code using HASONEVALUE ensures that a value is only returned if there is exactly one value selected in the OT_Month column.
Total Average only =
IF(HASONEVALUE(OTOnline[OT_Month]),[Average_OT_Per_48],BLANK())If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Not working I want OT monthly but OT Average for the year not month wise !
Not working I want OT monthly but OT Average for the year not month wise !
Hi Jalil239
Many thanks to danextian , mianjalil239 and dharmendars007 for their prompt reply. Let me add something here.
You may not be able to do this in the default design of power bi desktop, but let's try something else:
Solved: Matrix - Hide a column in visual but consider in c... - Microsoft Fabric Community
As mentioned in this post, you can turn off "Text wrap" in "Values" and "Column headers" and do this by adjusting the width.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
