Forum Discussion

_bs_'s avatar
_bs_
Advocate I
8 months ago
Solved

Matrix design help

Hello, I have a fact table showing Projects with roles and the planned hours & revenue along with actual hours & revenue. Sample data of fact: This joins to Date table using the FinishDate co...
Need Help
  • v-prasare's avatar
    v-prasare
    7 months ago

    Hi _bs_ ,

    Power BI Matrix visuals have inherent limitations. Row headers can only come from table columns, not measures, so measures like Planned Hours and Planned Revenue cannot be placed directly in Rows and are evaluated only in the Values area. Additionally, the Matrix does not natively support combining static planned values with time-based actuals.

     

    If the issue still persists on your end, we recommend reaching out to our Power BI certified solution partners. These are highly experienced professionals who can provide in-depth technical assistance and offer tailored solutions based on your specific needs. You can explore the list of trusted partners here:

    Power BI Partners | Microsoft Power Platform

    You’re always welcome to continue engaging with the community as well,
    Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread.
    we truly appreciate your active participation in the Microsoft Fabric Community.

     

     

    Thanks,

    Prashanth

     

v-prasare's avatar
v-prasare
Community Support
8 months ago

Hi _bs_,

As we haven't heard back from you, we would like you to please share the sample PBIX file shown above? This will help in understanding your scenario and providing an accurate solution.

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support