Forum Discussion
Post ProdigyCan i hide Graph to 0 value ???
hi , Red and Black Graphs are calculated from Green Graph as total Spend , in this case , i wanna hide the budget on Black and red to 0 value only the yellow description i highlighed. and the rest we can keep it the same.
5 Replies
v-piga-msftResident Rockstar
Hi Chanleakna123,
Based on your information, I have made a test to reproduce your scenario.
You could create two calcualted columns to achieve your desired output.
Column = IF('Table1'[Type]="D",0,'Table1'[Value1]) Column 2 = IF('Table1'[Type]="D",0,'Table1'[Value2])Here is the ouptut.
Best Regards,
Cherry
- Chanleakna123
Hi v-piga-msft , i used as per your instruction with below calculation in Column :
Spend for Dual Route = IF('Klahan + Broyuth + WS'[Description]="Budget plan for Aquarius CUP (Event Mng fee, Reward….)",0,[Total Spend Dual Route])and *Spend for Single Route , It shows the warning sign .May you help me what happen ?- v-piga-msft
Hi Chanleakna123,
Based on your images, it seems that the Spend for Dual Route is right, so for your sceanrio, if you want to hide the green bar of "Budget plan for Aquarius CUP..." to 0, you should create the calculated column like below.
Total Spend Dual Route= IF('Klahan + Broyuth + WS'[Description]="Budget plan for Aquarius CUP (Event Mng fee, Reward….)",0,[Total Spend Dual Route])
I have confused about how do you create the calculated column for Spend for Single Route. If it is convenient, could you share the screenshot of the Spend for Single Route formula so that I could see the warning and get the solution.
Best Regards,
Cherry
