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,
I have a pwoer BI table visual that contains data from 2 separate tables. The things is that sometimes data from one table might not exist. Currently when i try to visualize both of them it doesn't show cases that one is null.
Is there a way to overcome this?
I have a similar thing, where an item from one table is not in the other which results in a blank space.
Trying to come up with a solution that returns a 0 instead of a blank. Example pf visual.
Current formula:
Δ in Outstdng = CALCULATE(SUM('UAP_this_week'[Still Outstanding])) - CALCULATE(SUM('UAPl_last_month'[Outstanding-LstMth]))
Thx in advance for any assistance.
~dk
Hi @sundayDriver ,
Is that possible to filter the blank value out in power query? If it doesn't meet your requirement, kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |