Forum Discussion

kanth999's avatar
kanth999
Icon for Helper I rankHelper I
4 years ago

PowerBI Matrix visual need to be create like this

Hi Team,    I need to create the PowerBI Matrix visual like below , is it possible to create if yes can you please guide me how        
Need Help
Tips and Tricks
kanth999's avatar
kanth999
Icon for Helper I rankHelper I
4 years ago

Hi Mohan, 

 

thanks for your reply 

 

My requirement is quite different then normal, could you please check it again, same Quarter will need to be repeter vocore and Stage metrics separately . 

 

please check my image i've marked the requirement. 

 

Thanks,

kanth999's avatar
kanth999
Icon for Helper I rankHelper I
4 years ago

Hi Team, 

 

Please provide the solution anyone ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi kanth999 ,

     

    Power BI only support us to add columns in Row and Column Fields. And how matrix looks like is based on your data model.

    I think your data model should look like as below. The column with "Vcore Usage" and "Storage in GB" should be a higher level than [Quarter] column. 

    Result is as below.

     

     

    Best Regards,
    Rico Zhou

     

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

    • kanth999's avatar
      kanth999
      Icon for Helper I rankHelper I
      4 years ago

      Hi Rico,

       

      Thanks for reply !

       

      in my case Vcore and Storage GB both are measures not a dimension columns. if it's dimension column it's easey

       

       

      Please give me alternative solution