Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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)

 

 

 

  • Anonymous's avatar
    Anonymous
    3 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

    • Anonymous's avatar
      Anonymous
      Not 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. 

      • marcelsmaglhaes's avatar
        marcelsmaglhaes
        Super 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....