Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a matrix visual in Power Bi but need to arrange the values on top of the columns similar to this Excel pivot table. Is this possible in Power BI?
Solved! Go to Solution.
You can do that with a calculation group, using tabular editor. Create a calculation item for each measure (just use your measure as the expression in each, as shown in bottom pic) and use the column from the calc grp (default is "Name") in a matrix visual above your year column. You can then put any measure in the Values, as your calc grp will overwrite it.
Pat
You can do that with a calculation group, using tabular editor. Create a calculation item for each measure (just use your measure as the expression in each, as shown in bottom pic) and use the column from the calc grp (default is "Name") in a matrix visual above your year column. You can then put any measure in the Values, as your calc grp will overwrite it.
Pat
How can this be accomplished without a Calculation Group? Creating a calculation group disables implicit measures in Power BI, which ruins much of my report.
Hi
How would this work in the new Power BI Desktop and PowerBi Service Calculation group interface
I have created a calcilatin group with "Name" and then I have my measures I am dropping in with a current value (The value of the particular month), but I get this view
Month
Measure 1 | Measure 2
not
Measure 1 Measure 2
Month1 | Month 2 Month1 | Month 2
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
67 | |
60 |