Forum Discussion

deniseg's avatar
deniseg
Regular Visitor
5 years ago
Solved

Balance Scorecard Excel to PowerBI

Hello,   I would like to ask for your advice, is this type of balance scorecard card in excel can be done in PowerBI? Our management would like to have this exact same look in excel to be done the ...
Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi deniseg ,

     

    Here is a blog describes Power BI Conditional Formatting for Matrix and Table Visuals in detail. Please check if it could help you.

     

    In addition, for "showing both numbers and percentages", please check if "Show on rows" could help you.

     

    If all above don't work, please share us more details.

     

     

    Best Regards,

    Icey

     

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

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
5 years ago

Hi deniseg ,

Is the column grouping also required ? If not you can create a table with the required measures/ columns and apply the conditional formatting to get this view.

 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos ðŸ˜€

deniseg's avatar
deniseg
Regular Visitor
5 years ago

Column grouping is not required. with the tables, I am having trouble in showing both numbers and percentages. Do you have an example of how can I arrange the data for me to come up with this table?

 

I am quiet new to PowerBI and is only using it for 8 months.

 

Really appreciate your help.

 

Thank you,

 

Denise G.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi deniseg ,

     

    Here is a blog describes Power BI Conditional Formatting for Matrix and Table Visuals in detail. Please check if it could help you.

     

    In addition, for "showing both numbers and percentages", please check if "Show on rows" could help you.

     

    If all above don't work, please share us more details.

     

     

    Best Regards,

    Icey

     

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