Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Hi @v-piga-msft , i used as per your instruction with below calculation in Column :
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
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |