Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
PaulSGodden
Advocate I
Advocate I

Simple Table?

Hi,

Have a Power Automate job populating a SharePoint list

PaulSGodden_0-1681912137994.png

and am looking to create a dashboard with a simple table similar to:

PaulSGodden_1-1681912182173.png

Tried a few standard visuals and downloaded a couple but none do the job. Am assuming that I'm looking in the wrong place or its simple pilot error on my person. Any advice gratefully received. Thanks in advance

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @PaulSGodden,

After you are getting data to power side, you can do unpivoted column on these value fields(high, medium, low) to convert them to attribute and value. Then you can create a matrix with attribute as row , date field on column to reproduce these effects.

Unpivot columns - Power Query | Microsoft Learn

For add custom row to matrix, you may need to create a new table with raw row field value and new values.

Then you can use it on matrix row. You need to write a measure formula to use on value field to use current row context value to lookup row label value and reduce to different calculation formula.

Dynamic Rows and Dynamic Columns in Power BI Matrix visual using Slicers | by Raghvendra Pratap Sing...

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @PaulSGodden,

After you are getting data to power side, you can do unpivoted column on these value fields(high, medium, low) to convert them to attribute and value. Then you can create a matrix with attribute as row , date field on column to reproduce these effects.

Unpivot columns - Power Query | Microsoft Learn

For add custom row to matrix, you may need to create a new table with raw row field value and new values.

Then you can use it on matrix row. You need to write a measure formula to use on value field to use current row context value to lookup row label value and reduce to different calculation formula.

Dynamic Rows and Dynamic Columns in Power BI Matrix visual using Slicers | by Raghvendra Pratap Sing...

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors