A reminder that this is also available on my website, along with many more Data and Analytics tips! jammosanalytics.co.uk/2023/11/15/power-bi-matrix-blanks-to-zeroes-explained/ I’m always looking to improve, so if there’s anything you think I could do better or topics you’d like to see covered, feel free to share your thoughts below. Your feedback helps me grow!
I have a matrix visual where I am taking column value from Calendar table(month name & year) and row value from another table and trying to bring it . But still I am getting blank
community.fabric.microsoft.com/t5/Desktop/Summarize-Columns-Keeping-blank-rows/m-p/59577 Could be worth trying this, SUMMARIZECOLUMNS drops combinations that return blanks so you'll have the same problem
👍 perfect. In my scenario, I followed the similar approach but I pulled 1 column for dimension & rest other 4 columns from the original fact table..but when Im replacing blank with 0 the no. of records are duplicating. Total aggreg columns are 4 : 2-2 from 2 fact tables & rest other dim columns from 1fact table .
A reminder that this is also available on my website, along with many more Data and Analytics tips!
jammosanalytics.co.uk/2023/11/15/power-bi-matrix-blanks-to-zeroes-explained/
I’m always looking to improve, so if there’s anything you think I could do better or topics you’d like to see covered, feel free to share your thoughts below. Your feedback helps me grow!
Thank you for this - really helpful
Thank you very much
This is very useful. Thank you.
Thank, and how to replace 0 with blank ?
Thanks a lot ,it really helped, Keep going
I have a matrix visual where I am taking column value from Calendar table(month name & year) and row value from another table and trying to bring it . But still I am getting blank
how if want to use year as slicer, Will the data adjust to the slicer?
I believe so, the built in date dimension should mean it does
what if I wanna remove banks from only last column? and keep rest the same
In that case, you can use the columns from the dimension table as explained, but pull the last column from your original table. Hope this helps!
This is not working still for me
Are you sure you're using the columns from the new tables rather than the old?
@@jammosanalytics6959 yes , tried the same as you suggested But it is a summerized column is that ok
community.fabric.microsoft.com/t5/Desktop/Summarize-Columns-Keeping-blank-rows/m-p/59577
Could be worth trying this, SUMMARIZECOLUMNS drops combinations that return blanks so you'll have the same problem
👍 perfect. In my scenario,
I followed the similar approach but I pulled 1 column for dimension & rest other 4 columns from the original fact table..but when Im replacing blank with 0 the no. of records are duplicating.
Total aggreg columns are 4 : 2-2 from 2 fact tables & rest other dim columns from 1fact table .