Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
Kindly help me create shared column header in matrix.
Ex:
thank you.
Hi @Snagalapur
Assuming you have a table similar in structure to this:
You could put your period and metric fields on the columns field well and expand down:
Result would look like this:
Alternatively, you can create a disconnected table very similar to this:
And you can create a measure with a switch statement to return the correct value(s):
MyValue =
// retrieve column metric
VAR _Metric = SELECTEDVALUE(Metric[Metric])
RETURN
// return value for specified metric
CALCULATE(SUM('Table'[Value]), 'Table'[Metric] = _Metric)
thank you so much for details but my data is in same format as mentioned here, not sure how to handle
Hi @Snagalapur ,
You would need to go into PowerQuery do some table transformations to unpivot those columns. You'll likely hearthe phrase: "go long instead of wide" many times throughout your BI journey.
So if your table structure is like this:
You would need to select all the columns that doesn't need pivoting like so:
Then right-click and of those columns and click "unpivot other columns"
And your result should look similar to this:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |