Forum Discussion
Power BI matrix query
I am a total Power BI newbie. I have a document library in SharePoint and I want to know the percentage of documents that are in date - by that I mean that haven't passed their review date.
I have got a matrix displaying the data, see below but I don't want the Current Percent In Date column to be duplicated. I only want it at the end after the Total Count of ID but can only seem to get it like the below. Why is this?
Thanks for your help.
Hi SK1234
Thank you for reaching out to the Microsoft Fabric community.
Regarding your query on displaying the “Current Percent In Date” in a Power BI matrix without repeating it for every row:
While the exact structure of your dataset is not fully known, a sample dataset and I’ve created a sample .pbix file to demonstrate one possible solution by creating a measure:Current Percent In Date = DIVIDE([Count In Date], [Total Count of ID])
Please refer to the attached .pbix file for a working example and review the implementation.
I hope this information proves helpful. If not, please feel free to share additional details, and we will be happy to assist you further.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.
9 Replies
Hi SK1234 ,
Looking at your matrix, I can see that "Current Percent In Date" is appearing multiple times when it should only show once. This usually happens for a couple of specific reasons:
Most Likely Issue: Duplicate Fields Check your Values section in the field well. You might have accidentally added "Current Percent In Date" twice. Simply remove one of them by clicking the X next to the duplicate entry.
Alternative Issue: Field Placement The percentage measure might be placed in the wrong section. Make sure "Current Percent In Date" is only in the Values area, not in Rows or Columns sections.
Quick Fix Steps:
- Look at your Fields panel on the right
- In the Values section, check if "Current Percent In Date" appears more than once
- If it does, remove the duplicate(s)
- If it's only there once, try removing it completely and adding it back
If the above doesn't work: Your measure might be calculating at each row level instead of just totals. Without seeing your DAX formula, it's hard to say exactly, but the measure should be designed to show percentages appropriately for each grouping.
Could you double-check your Values section in the field well and let me know what you see there? That would help pinpoint the exact cause.
More details on matrix configuration can be found in Power BI matrix documentation.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.
Hi SK1234
Thank you for reaching out to the Microsoft Fabric community.
Regarding your query on displaying the “Current Percent In Date” in a Power BI matrix without repeating it for every row:
While the exact structure of your dataset is not fully known, a sample dataset and I’ve created a sample .pbix file to demonstrate one possible solution by creating a measure:Current Percent In Date = DIVIDE([Count In Date], [Total Count of ID])
Please refer to the attached .pbix file for a working example and review the implementation.
I hope this information proves helpful. If not, please feel free to share additional details, and we will be happy to assist you further.
Regards,
Karpurapu D,
Microsoft Fabric Community Support Team.Power BI shows all the columns grouped so you cannot remove a column only in some circumstances
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi SK1234
We have not yet heard back from you about whether our response addressed your query. If it did not, please share more details so we can assist you more effectively.
Thank You.
Thanks to all for your suggestions - very helpful. Unfortunately I haven't had much time to spend on this issue and so haven't got to a resolution yet. From v-karpurapud's sample file it looks as if I need to adjust my data which causes me difficulties elsewhere. I am not sure when I will get chance to look at the issue again as I am covering for people on leave but I am genuinely grateful for your assistance.
Hi SK1234
Thank you for the update. Looking forward to your response.
Regards,
Karpurapu D.
Hi SK1234 ,
Just checking in to see if you’ve had a chance to look into the issue, or if there’s anything else we can help with. Let us know if you need anything!
Thank You.Thank you to everyone that responded to my query and especially to v-karpurapud whose sample pbix file allowed me to see where I was going wrong. I have now resolved the issue and am really grateful for your support, it is invaluable. In the end I created measures for the In Date and Out of Date statuses rather than let Power BI pivot on the status column.
Now on to the next challenge.
Thanks once again for your help.
Kind regards
Sue Kondakor
