Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Matrix report

I am trying to create a report which shows the data of the pervious year data from the selected year in a slicer in a yearly format & the selected year data slicer in months..   For example: I sele...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    It there a way to integrate that in the existing calander table

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous (1) The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community

If that doesn't help, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Greg_Deckler ,

     

    The suggestion that you gave will work, I might have to make few changes. I just wanted to see how to show all the 12 month by default. As if we select the pervious fiscal year. I am able to see all the month but when the current fiscal year is selected it will only show the month that have passed. I need that to remain static as I need the visual to remain in the same size. If you see the below screenshot. Which shows the data of the pervious 3 fiscal years. And the Last fiscal year is spread out in months.

     

    If there is any suggestion regarding that.

     

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      3 years ago

      Anonymous If I'm understanding what you want correctly, I think that is just a bridge too far for the matrix visual to have columns kind of reorder themselves like that. Maybe, again, if you constructed your disconnected table and measure just right, maybe. I an thinking three columns in your disconnected table. 

      Category Sort Year
      APR 1 2021
      MAY 2 2021
      JUN 3 2021
      FY 21 4 2021
      JUL 5 2022
      AUG 6 2022
      SEP 7 2022
      OCT 8 2022
      NOV 9 2022
      DEC 10 2022
      JAN 11 2022
      FEB 12 2022
      MAR 13 2022
      ARP 14 2022
      MAY 15 2022
      JUN 16 2022
      FY 22 17 2022

       

      So basically you could contruct your measure that based on the slicer selection, let's say 2022, it only shows the months for 2022 and it shows all of the FY. If they select 2021 then it shows the 2021 months, etc. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        It there a way to integrate that in the existing calander table