Forum Discussion

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
5 years ago
Solved

How to Create Color coded Table which has all measures as Values to show in the Table.

Hi All, I want to show a color code table in my power bi report which has all measures as values as below:    ex: Measure1 is the name of the measure and 10 is the result of the measure i tried t...
Need Help
Show and Tell
Tips and Tricks
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi SantoshKumar ,

     

    Not sure why it's not working at your end. I tried at my end using CARD visual for these 3 measures along with Text Boxes to label them on the left and they work pretty well:

    You can modify background colours, text size, etc. based on your requirement.

     

    How many measures do you have?

     

    Thanks,

    Pragati

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
5 years ago

Pragati11 i have attached the snapshot but unfortunately it is not showing once i submitted the post.

below is the snapshot which is the expected table.

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi SantoshKumar ,

 

Is this really an expected output? I mean you don't have any columns in this table just the measures. Is that right?

If it is just measures,

  1. create individual card visuals for each of your measures - you will have like 5 cards
  2. Give required backgound color to these card visuals
  3. Add text boxes to give name for your masures
  4. Give required colours for these text boxes as well
  5. stack all of these text boxes and card visuals on top of each other 

Thanks,

Pragati

  • SantoshKumar's avatar
    SantoshKumar
    Microsoft Employee
    5 years ago

    Pragati11  Yes , my requirement consists of only measure. i have already tried scorecards and text boxes but it is not looking good when its viewed and i thought there could be some other options to represent my data in more convenient way.

    • Pragati11's avatar
      Pragati11
      Super User
      5 years ago

      Hi SantoshKumar ,

       

      Not sure why it's not working at your end. I tried at my end using CARD visual for these 3 measures along with Text Boxes to label them on the left and they work pretty well:

      You can modify background colours, text size, etc. based on your requirement.

       

      How many measures do you have?

       

      Thanks,

      Pragati

      • SantoshKumar's avatar
        SantoshKumar
        Microsoft Employee
        5 years ago

         Pragati11 

        Hi Pragati,

        I have not said like it is not working but its looks like kind of messy because per now i have  5measure, 5 text boxes which i have to show in smaller boxes in size, then need to align, next have to group them to move across the page.
        if any changes required then have to ungroup them and follow the process.
        instead of this i was looking for any visual which can be available to make it simplier.

        Regard

        Santosh