DAX Aging bucket for two different Column

[rdnguyen]

Hi all,

I have a table that calculate Age days (calculated columns) based on Actual and Planning date. Then based on Selection, I let user view Aging either from Age days by Actual or Planning.

Now, come to the Pie chart, how could I set up so that Pie chart legend which is Aging buckets could filter the visual table for record viewing? 

Could you please advise.

[Anonymous · Accepted solution]

Hi @rdnguyen,

You can consider adding a new column to your table to group the 'age days' based on detailed segmentation. Then you can use the segmentation field on pie chart as legends.

Dynamic segmentation – DAX Patterns

Static segmentation – DAX Patterns
Regards,

Xiaoxin Sheng