Can i hide Graph to 0 value ???

[Chanleakna123]

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. 

[v-piga-msft]

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

[Chanleakna123]

Hi @v-piga-msft i tried yours and it doesn't work , and when i plug the data in filter visualization , it shown nothing , no value. 

[v-piga-msft]

Hi @Chanleakna123 ,

If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.)

Best  Regards,

Cherry