Forum Discussion
Simple Table?
Hi,
Have a Power Automate job populating a SharePoint list
and am looking to create a dashboard with a simple table similar to:
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
HI Anonymous,
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.
Regards,
Xiaoxin Sheng
1 Reply
HI Anonymous,
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.
Regards,
Xiaoxin Sheng