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 there,
I am hoping someone is able to provide some valuable assistance on my problem.
I have a matrix visual as follows:
The first column is a measure with the following formula:
% of Workforce Compliance (Item) = DIVIDE([# of Compliance Users (Assigned an Item)],[# of Users (Assigned an Item)],0)
The second column is as follows:
Solved! Go to Solution.
Hi @Anonymous ,
Have you ever tried show item with no data for rows?
As a workaround, you can hide the column in the matrix that you don't want to show by colsing the word wrap in values and column headers and drag and drop the width of column:
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 ,
Have you ever tried show item with no data for rows?
As a workaround, you can hide the column in the matrix that you don't want to show by colsing the word wrap in values and column headers and drag and drop the width of column:
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
It's a good idea but there is actually many columns that I have in the table.. I just showed the example table with 1 column. If I do this for all of them, then most of the columns I want to show will be reduced in size and there will be too many columns to manually go through a resize. I also believe that blank values will no come through even with this selected, although admittedly I haven't tried it.
I feel that must be a way of handling this via the measure, but I cannot come up with an answer.
Hi @Anonymous ,
Would you please try to use show item with no data?
Best Regards,
Dedmon Dai
I tried the "show data with no data" option and although it didn't completely solve my issue, it allowed me to continue working the problem and I have now worked out how to do what I want. Thanks so much!!!
Regards.
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |