Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
omerpq
Regular Visitor

Replacing Values in the Visual (Calculated) Column

Dear All:

All the best in all the reporting. I am too new to Power BI but the current stage where I am stuck has made me Go Through Power BI a lot. A blessing in disguise. 🙂

I need to Replace the values in the Column of Visual (obviously the column is showing values on specific conditions on the source) with the Values of another Column on the same visual, if the first column calculates any null values.

Please help in this regard.

As you can see below, i want to replace the values in Comm Veh Avg Pay (4th Column) if it is blank with the respective value in Total (ZF10 CC) (5th Column) if that is again blank, then with the values of next column which is Private Veh Cost. 

I am stuck since days, please help in this regard. Thanks in Advance as well.

For Community.PNG

2 ACCEPTED SOLUTIONS

=IF([Measure1]=blank(),[Measure2],[Measure3]) 

or some variation.  You can use nested IF if needed, or even SWITCH TRUE

https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

I mean you should write a measure that reacts to the circumstances that are presented in the visual.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

4 REPLIES 4

=IF([Measure1]=blank(),[Measure2],[Measure3]) 

or some variation.  You can use nested IF if needed, or even SWITCH TRUE

https://powerpivotpro.com/2015/03/the-diabolical-genius-of-switch-true/



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

THANKS for the reply, did you mean that I need to create the Columns in visuals using "new measure"? Instead of using "New Column" or making the column calculated by the VISUAL TABLE'S filters?

I mean you should write a measure that reacts to the circumstances that are presented in the visual.



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Perfect solution you have quoted Matt... very nice. My issue resolved as well.

I have had been stuck since days over it.. Good Luck.

Thanks,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.