Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Dynamic columns in table visual based on slicer selection

I have a slicer with following value

ID,Name,Category


Need to create table visual where Sales and Profit values remains consistant but based on slicer selection based on slicer selection columns shoould change.

If i select ID then my table visual should consist of ID, Sales and Profit columns.

Kindly do the needfull
Thanks

4 Replies

  • Hi Anonymous,

     

    you can use Filed parametes to switch between fields, Go to Modeling β†’ New Parameter β†’ Fields and create a parameter with the required columns.

     

    Here is the DAX to create the same

    ColumnSelection =
    {
    ("ID", NAMEOF('SalesData'[ID]), 0),
    ("Name", NAMEOF('SalesData'[Name]), 1),
    ("Category", NAMEOF('SalesData'[Category]), 2)
    }

    Now create table visual, as ColumnSelection, Sales and Profit.

    Use field parameter in slicer, now when filtering the slicer table values will update as per the selection.

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    πŸ’‘ Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    πŸŽ– As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    πŸ”— Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

  • Hello Anonymous ,

     

    You can use field value parameters under parameters under modelling tab in Power BI Desktop and it will help you to fulfill your requirement. 
    Please refer below video for the steps:

    https://youtu.be/1eurc0EY2Xg?si=HYzys1bSwHzxZnz8

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!