trying to make a table

Question

Im essentially trying to recreate this colored table in BI.&nbsp; I have all the data in BI but i have no idea how to create the data into a pivot table which would give me the values for the table.

greg_deckler · Answer

Is this in Excel or Power BI Desktop? In Desktop, you would use a matrix visualization and then you would need to use Conditional Formatting most likely.

shantanu00007 · Answer

You need to create 3 mesures for row and select region in column for matrix visuals.

dkehoe32 · Answer

The picture is from excel and i want to recreate it in BI

shantanu00007 · Answer

You need to create 3 seperate tables and align them in such a way that it looks like a table. I guess this is the only workaround in powerbi.

anonymous · Answer

Hi&nbsp;With Measures, you can do this in Matrix visual, for background colouring, you need to use conditional formatting.&nbsp;If you need more details, you need to share how your source data looks like.&nbsp;ThanksRaj

Forum Discussion

trying to make a table

5 Replies

Related content

Trying to make a calc table of 2 related tables filtered by Table 1 field, getting all Table 2 rows

Trying to write data to Delta Table

went to try making my mobile responsive...but...

Trying to make a flat copy, rather than keeping references permanently

Make a table or matrix transparent