Custom Column Selection with 2 levels

[jharvam]

Hello guys,

I need help with little complicated matrix visual.

I am using SWITCH calculation to show data from my source table based on unique key column in rows as I want it. All works perfectly. They based on another key column I set up som more calculations into the visual. These are all financial data. One for the columns describes scenario of the data. They can be Actual, Plan or Outlook.

What I need now is to show the same visual with three columns for each of these scenarios with ability to select which scenrio I want to show and which year. Separately for all 3 sections. Then second level would be fiscal year quartals which would remain the same.

I was thinking if I can somehow set up custom column structure which I can import into Matrix visual, because I am not able to use Measure as column.

Thank you

Milan

[Icey · Accepted solution]

Hi @jharvam ,

Please give me some sample data or just your PBIX file without sensitive information. I suggest you to use OneDrive for Business. Attach the link.

Best Regards,

Icey

[jharvam]

Hi,

thanks a lot, I have already solved it. I have changed the requirements little bit. 

Thanks

Milan

[Icey]

Hi @jharvam ,

Glad to hear that. Please accept your reply above as a solution.

Best Regards,

Icey