Forum Discussion

DevMaster's avatar
DevMaster
Regular Visitor
3 years ago
Solved

Unable to display values in Level2 and Level3 Matrix visual in Power Bi

I am trying to create Level1, Level2 and Level3 matrix visual and unable to display custom calculations in Level2. below is the sample data to construct the visual.   Data: Level1 Level2 Leve...
Need Help
Tutorial Requests
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    If I understand you correctly and your desired result is : 

    You can modify it from the subtotals format with these steps:

    I also updated the linked file

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • DevMaster's avatar
    DevMaster
    3 years ago

    Thanks a lot. it resolves all my issues.

DevMaster's avatar
DevMaster
Regular Visitor
3 years ago

Thank you for solution. Here i am facing one issue like i don't want to show Total text in the report. if i set subtotals option to off then values not showing. 

 

Could you please suggest that how we need to get rid off row/column subtotals.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

If I understand you correctly and your desired result is : 

You can modify it from the subtotals format with these steps:

I also updated the linked file

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • DevMaster's avatar
    DevMaster
    Regular Visitor
    3 years ago

    Thanks a lot. it resolves all my issues.

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Happy to help, please  consider Accepting  all answers that help with different issues of this post as the solutions to help the other members find it more quickly