Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |