Forum Discussion
Yet another difficult Power BI question
Don't you wish the people who request these reports walked in your shoes for a day before they ask for crazy azz things to be done in Power BI?
Okay here is report. It is a table report. It is fully dynamic. Meaning the columns are dynamic. I can change the columns to include for example either all 4 quarters and the total or select one quarter and just see the months results for that quarter. (See the slicer which you can use to do this). Every column is a calculation starting from Bench down.
Line and Text are not calculated and just regular ordered columns in a table.
My question is this : Given that I had to use calculated columns to create the dynamic columns, my boss wants to be able to expand the column Text from a Summary view to an Expanded PnL view. I created bookmarks as you can see that show both views. But as you know that is not an ideal solution. Is there a way to do this without using bookmarks?
Here is the Summary view:
Here is the expanded PnL view : (notice how the quarter columns changed with the selection of Q1 in the slicer)
- Anonymous3 years ago
Add another column to table containing the P&L listings. Add 1 for the summary items. 0 for the expanded items. Then use a slicer. Have it selected at 1 for the summary view. Unselect everything for the expanded view.
5 Replies
- marcelsmaglhaesSuper User
Hey Anonymous !
Maybe you can use Matrix visual instead of table visual. Take a look: Create a matrix visual in Power BI - Power BI | Microsoft Learn
Regards,
Marcel- AnonymousNot applicable
I don't think that would work because the columns are dynamic columns. They are all calculations. If I switch from table to matrix in Power BI, it says it ran out of resources and the visual won't display.
- marcelsmaglhaesSuper User
Oh, i dind't realize the dinamics column. Well, I can't think in better idea than use bookmarks. It is not an ideal solution, but is a solution....