Calc groups and table visual - do they work together?

[Dellis81]

Hello - I am attempting to use a calculation group items within a table visual.  However, when inserting the calculation group - the table seems to be converted to multiple rows for each calculation item (dollars, quantity, $/Quantity).

When I convert the above table to a matrix - my calculation table items are now columns.  But requires drill down.

I like the way calculation groups prevent (hide) the display of certain measures (columns) if no data is available.  Using traditional measures - there is a column displayed, whether or not data is available.
1)  Can we use calculation groups within tables - and force as columns?
2)  Is there a way to format matrix visual to look like a table (no drilldown bottons and "rows filled in from above", like we have in excel pivot tables?

thank you!

[amitchandak · Accepted solution]

@Dellis81 , Calculation groups convert measure names into dimensions, you can check if field parameters can help

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE

[Dellis81]

Thank you for your response.  Yes, I understand calculation groups are treated as dimensions, but surprised in a table visual, those dimensions converted to rows vs columns.   For a work around, was able to use a step - layout as off within a matrix and got close to what I was hoping for.   The downside - my user's are expecting a table experience, but as you know the stepped layout matrix is formatted slightly different.  I find change is hard for those not wanting change...

I did a little review of your referenced blogs, and intrigued by your profit/loss financials with blank rows.  I hope to work on those concepts next few days.  Thank you 🙂