Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
hi all
I have one problem which let me headache for days and wish to seek help your support.
My scenario is quite simple, to compare the sales of certain product on a yearly basis in the matrix visualization.
The table used called CarSales, and the contents as follows, the measure I created called Measure_GAP, coding as follow,
Thanks in advance for solving the problem for me!
Best Regards
Yurong ZHANG
Solved! Go to Solution.
Hi @yurongzhang,
Theses 'blank' cells should be due to your table records. If they not really include in your tables, the measure expressions will not calculate on not existent range and keep show blank results. (measure not able to work as category/axis fields to expand the calculations ranges, they can only calculate with current row context)
BTW, power bi also include an auto existed filter effect on visual to hide the field which not has correspond values. They has higher priority than your measure formulas calculation and will auto filter to hide these fields.
For this scenario, I'd like to suggest you check the row/column field which not has correspond records and create a new unconnected table with that field values to replace the raw field which matrix used.
After these steps, you can modify your formula to check current row and column value as condition and lookup and summary table records.
Regards,
Xiaoxin Sheng
Hi @yurongzhang,
Theses 'blank' cells should be due to your table records. If they not really include in your tables, the measure expressions will not calculate on not existent range and keep show blank results. (measure not able to work as category/axis fields to expand the calculations ranges, they can only calculate with current row context)
BTW, power bi also include an auto existed filter effect on visual to hide the field which not has correspond values. They has higher priority than your measure formulas calculation and will auto filter to hide these fields.
For this scenario, I'd like to suggest you check the row/column field which not has correspond records and create a new unconnected table with that field values to replace the raw field which matrix used.
After these steps, you can modify your formula to check current row and column value as condition and lookup and summary table records.
Regards,
Xiaoxin Sheng