Forum Discussion
Custom Column Selection with 2 levels
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
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