Forum Discussion
Dynamic Value
Hello All,
My requirement is to identify a group of age from an age column using a filter. While the filter value is 10 means, I want the x-axis value as the sum of 10 like 0-10,10-20......etc.depends upon data.
Actually, I did this one with static data by using the age group method in the table.
But I want to generate age difference(0-10,10-20......) dynamically based on slicer value, without static data how can I achieve this one.
Please help with this one. Thanks in advance.
Hi Anonymous ,
Here are the steps you can follow：
1. Use column [Attribute] as slicer.
2. Create measure.
measure_value = var _select =SELECTEDVALUE('Table'[Attribute]) var _age1=SUMX(FILTER('Table','Table'[Attribute]=_select),[Age] var _age2=_age1+_select var _age3=_age1-_select return SWITCH( TRUE(), _select in {2,5,6},_age1 &"-"& _age2, _select in {3,4} ,_age3 &"-"& _age1)3. Result:
When Attribute=2 is selected, it is displayed as:
When Attribute= 3 is selected, it is displayed as:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
Hi Anonymous ,
Here are the steps you can follow：
1. Use column [Attribute] as slicer.
2. Create measure.
measure_value = var _select =SELECTEDVALUE('Table'[Attribute]) var _age1=SUMX(FILTER('Table','Table'[Attribute]=_select),[Age] var _age2=_age1+_select var _age3=_age1-_select return SWITCH( TRUE(), _select in {2,5,6},_age1 &"-"& _age2, _select in {3,4} ,_age3 &"-"& _age1)3. Result:
When Attribute=2 is selected, it is displayed as:
When Attribute= 3 is selected, it is displayed as:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous , Power Bi Axis has come from some static columns at the end. while you can create a measure with those values. I doubt you can use that on axis
