Forum Discussion

EugenioProlog's avatar
EugenioProlog
Icon for Helper III rankHelper III
11 months ago
Solved

Choose column on dim table based on field parameter

I have this Matrix table using several metrics on my fct_deals table and my dim_deals table.
I have one single dimension of my dim_deals table (lets say dimension_A) as Rows of the Matrix table. I would like to create a Field Parameter in which I can choose between dimension_A,dimension_B,dimension_C to display in the Rows of my matrix. Is that possible?

 

  • hello EugenioProlog 

     

    perhaps try adding dimension_A, dimension_B, dimension_C in field parameter?

    ("Dimension_A", NAMEOF('DIM tabl'[Dimension_A]),0) and so on.

     

    Thank you.

2 Replies

  • v-karpurapud's avatar
    v-karpurapud
    Icon for Community Support rankCommunity Support

    Hi EugenioProlog 

    Thanks for reaching out to the Microsoft fabric community forum. 

     

    I would also take a moment to thank  Irwan , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

    I hope the below details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

       

    Best Regards, 
    Community Support Team  

  • hello EugenioProlog 

     

    perhaps try adding dimension_A, dimension_B, dimension_C in field parameter?

    ("Dimension_A", NAMEOF('DIM tabl'[Dimension_A]),0) and so on.

     

    Thank you.