Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
3 years ago
Solved

Represent Dynamic Table Visual based on Slicer Selection

Hi Friends, I have a requirement where I need to represent data in the below format so what is the best visual I can use and how can I achieve the same? Columns 1 and 3 are Fixed headers while the ...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi prabhatnath ,

    I updated my sample pbix file(see the attachment), please check if that is what you want.

    1. Create a dimension table as below

    2. Create a measure as below

    Measure = 
SWITCH (
    SELECTEDVALUE ( 'Table'[Type] ),
    "User Stories", [Count of User Stories],
    "Story Points", [Sum of Story Points],
    "Completed Work", [Sum of Completed Work],
    "Remaining Work", [Sum of Remaining Work]
)

    Best Regards

prabhatnath's avatar
prabhatnath
Advocate III
3 years ago

Thank you for your help on this.

Actually, I am able to get a table as normal with columns as headers and rows as values, but I was looking to represent the table as below:

 

Where Columns 1 and 3 are Headers/Fixed string and Columns 2 and 4 are based on Slicer selection..

Selected SprintSprint S103Original Estimate289
User Stories39Completed Work69
Story Points117Remaining210


Sorry if my earlier question was not clear.

Thanks,

Prabhat

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi prabhatnath ,

I updated my sample pbix file(see the attachment), please check if that is what you want.

1. Create a dimension table as below

2. Create a measure as below

Measure = 
SWITCH (
    SELECTEDVALUE ( 'Table'[Type] ),
    "User Stories", [Count of User Stories],
    "Story Points", [Sum of Story Points],
    "Completed Work", [Sum of Completed Work],
    "Remaining Work", [Sum of Remaining Work]
)

Best Regards