Forum Discussion
Display two remarks as one
i have bart chart with legend as remarks
remarks are
- a
- b
- c
- d
now here i need to display b and c values at a time and according to that chart will change
like
- a
- b & c
- d
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
Put it into the visual object to display:
1. Create measure.
Flag = var _sum=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]=MAX('Table'[group]))) var _SumB=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]="B")) var _SumC=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]="C")) RETURN IF( OR(MAX('Table'[group])="B",MAX('Table'[group])="C")&&OR(MAX('Table'[date])=2016,MAX('Table'[date])=2017),_SumB+_SumC,_sum)2. Result:
In 2016 and 2017, the value of B and C displayed in the visual object is the added value, and the rest remain unchanged
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
5 Replies
HI Anonymous ,
Not sure on what you are asking here. Try to add more details like sample data, screenshots of charts, etc.
Refer following to understand what details can be added to a query and how:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Thanks,
Pragati
Anonymous I am not quite well sure and understood your issue. But what I got is that you want to club together the remark value b & c. is this right?
Hi Anonymous ,
I created some data:
Here are the steps you can follow：
Put it into the visual object to display:
1. Create measure.
Flag = var _sum=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]=MAX('Table'[group]))) var _SumB=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]="B")) var _SumC=CALCULATE(SUM('Table'[amount]),FILTER(ALL('Table'),'Table'[date]=MAX('Table'[date])&&'Table'[group]="C")) RETURN IF( OR(MAX('Table'[group])="B",MAX('Table'[group])="C")&&OR(MAX('Table'[date])=2016,MAX('Table'[date])=2017),_SumB+_SumC,_sum)2. Result:
In 2016 and 2017, the value of B and C displayed in the visual object is the added value, and the rest remain unchanged
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
