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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi prabhatnath ,

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

Count of User Stories = 
CALCULATE (
    COUNT ( 'data'[Sprint Name] ),
    FILTER (
        'data',
        'data'[Work Item Type] = "User Story"
            && 'data'[Is Current] = TRUE ()
    )
)
Sum of Story Points = 
CALCULATE (
    SUM ( 'data'[Story Points] ),
    FILTER ( 'data', 'data'[Is Current] = TRUE () )
)
Sum of Original Estimate = 
CALCULATE (
    COUNT ( 'data'[Original Estimate] ),
    FILTER ( 'data', 'data'[Is Current] = TRUE () )
)
Sum of Completed Work = 
CALCULATE (
    SUM ( 'data'[Completed Work] ),
    FILTER ( 'data', 'data'[Is Current] = TRUE () )
)
Sum of Remaining Work = 
CALCULATE (
    SUM ( 'data'[Remaining Work] ),
    FILTER ( 'data', 'data'[Is Current] = TRUE () )
)

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