- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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! 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
01-16-2024 01:26 AM | |||
03-25-2024 10:39 PM | |||
02-13-2024 12:56 AM | |||
07-03-2023 04:20 PM | |||
02-04-2024 05:18 AM |
User | Count |
---|---|
87 | |
81 | |
53 | |
37 | |
35 |