Forum Discussion
Fill empty spaces in Matrix Power BI
** Disclosure - I've had mixed results with this method depending on values and the DAX of value you are showing. It seems like the more complex my Logix / Matrix, the less often it works...
See where I 'filled' this Matrix by replacing my Values with a Measure. Only 3 'Real' Data Lines, the rest are from the Measure...
Blank_Check = if ( SUM(Matrix[Value]) = 0, "0", SUM(Matrix[Value]))
** Disclosure - I've had mixed results with this method depending on values and the DAX of value you are showing. It seems like the more complex my Logix / Matrix, the less often it works...
See where I 'filled' this Matrix by replacing my Values with a Measure. Only 3 'Real' Data Lines, the rest are from the Measure...
fhill,
its just amazing.
i really appreciate your help.
it worked fine,
just little comment, probably is not necesary to expand to last month of year. i mean, all my data is calculated to 2020 august, but the calculate measure gives info until december
Try a Filter on the Visual to limit the trailing Months. Happy to help, glad it worked for you in this instance.
Forrest