Is there a way within a matrix visual to display all columns for 1 value but only 1 column for a 2nd value?
I thought I found a work around by shrinking the columns I dont want to see to be not existent. That works but when the data refreshes each week it reformats the columns and no longer displays as I need it to. It behaves that it holds on to the format of the specific column, not the column number as excel would.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com