Forum Discussion

jharvam's avatar
jharvam
Frequent Visitor
6 years ago
Solved

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

3 Replies

  • Icey's avatar
    Icey
    Community Support

    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's avatar
      jharvam
      Frequent Visitor

      Hi,

       

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

       

      Thanks

      Milan

      • Icey's avatar
        Icey
        Community Support

        Hi jharvam ,

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

         

        Best Regards,

        Icey