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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
vinnylad
Regular Visitor

Creating a simple table to display unrelated values

Hi All

 

Thsi is a novice request, but i just cant work out how to construct this.  I am creating a report for business consumption that requires a simple summary list of values to be displayed.   This is effectively an executive summary front page which will roll up values from all the items we are tracking in the wider PBI report for quick digestion of management. 

 

The measures displayed in the exec summary table will effectivley be unrelated to each other, so im just looking to display a custom row header / literal with an approriate measure / value alongside it (see sample image).  The measures will react to date slicer only.  The creation of the measures is not a challenge - just the displaying of them.

 

I apologise if this is 101.  Ive done my starter courses, but they seem more focused on using cool features for handling complex data, rather than displaying / formatting the arrangement of data .  Would appreciate any steer here!

 

Thanks

 

 

 PBI Forum.PNG    

1 ACCEPTED SOLUTION

Sounds like you need to build a field parameter and load the measures into it. Then for Column 1 you'd put the parameter name column and the values would go in column 2

View solution in original post

4 REPLIES 4
claymcooper
Resolver II
Resolver II

Hi @vinnylad You mentioned a image in your initial post but I don't see one. Could you provide one? or a sample of what your are trying to accomplish

ah - sorry.  I embedded an image into the request (just the simple excel style table you see under my 'thanks').  In case its not showing, ive included it again here.  So, simply column one 1 I want to put custom headers....and column 2 some custom measures.  Each row is not related to the row above or below...each of the headings / measures are kinda of stand alone.  So yeah, the sort of thing you do in 1 minute in excel and im pulling my hair out with PBI!  🙂

 

PBI Forum.PNG

 

Sounds like you need to build a field parameter and load the measures into it. Then for Column 1 you'd put the parameter name column and the values would go in column 2

Thanks Clay.  I was kinda hoping that wasnt the case TBH!  LOL.  Kinda funny all the complex things we can do in PBI, but we cant arrange this - the simplest of tasks - without creating an array of variables etc.  Anyway, really appreciate you taking time out to look at this.  Cheers!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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