Forum Discussion

UmairKamal's avatar
UmairKamal
Icon for Helper I rankHelper I
7 months ago
Solved

Field Parameters + multiple calendar systems: how to filter a cohort matrix by a single selected yea

Dear Users,   I’m building a cohort-style matrix in Power BI using Field Parameters to switch between two calendar systems: Financial Year (Apr–Mar) Reporting Year (Oct–Sep) The matrix axis s...
Need Help
  • UmairKamal's avatar
    UmairKamal
    7 months ago

    Thanks for finding the workaround. I have found a simpler way by creating another slicer  and using the default functyion of show values of the selected field.

danextian's avatar
danextian
Icon for Super User rankSuper User
7 months ago

Hi UmairKamal 

Without using measures, a workaround is to use a table that contains all the categories and their corresponding values. This pattern combines multiple categories into a single table with columns for type, value, and sort order. As the months have different sort orders and Power BI does not accept multiple sort values, this must be enforced using Tabular Editor. This table then needs to be related the actual calendar table in a many-to-many relationship

 

Please see the attached pbix.

UmairKamal's avatar
UmairKamal
Icon for Helper I rankHelper I
7 months ago

Thanks for finding the workaround. I have found a simpler way by creating another slicer  and using the default functyion of show values of the selected field.

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    7 months ago

    Hi UmairKamal,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you FBergamaschi and danextian for the prompt response.

     

    Thank you for the response and confirming that the issue is resolved now. Thank you for being part of Microsoft Fabric Community.

     

    Thanks and regards,

    Anjan Kumar Chippa