This is great! To be honest never paid any attention to the "broken lines". Just avoided many-many relationships and never worked with composite models that much :). I guess the smart use of "Dual Mode" for the objects on the link between the continents is the way to go in this kind of models to be sure the blank rows shows when it needs to?
I appreciate the blank row, and I know why I have the blank row in my data. I just wish there was an easy way to collapse it into another category on my dimension table when I choose. Otherwise my connection to the data source for the dimension will also have to have to append an anti-join to the fact table to add the missing rows to the dimension table source. Easy enough with SQL, but in the real world data isn't perfect, and executives with room temp IQs don't understand "blank".
Hello, Is it possible to put measures in rows of matrix but in row will be also other variable and measures will be above this variable? Thanks in advance
You can do that in Excel but not in Power BI - a possible workaround is moving measures to a calculation group or create a measure that chooses the actual calculation based on a slicer selection.
@@mariuszkrzemien6576 Well, for Matrix Visual there is a switch in "Values/Options" Section of properties. Where you can turn on "Switch values to rows". Should do the trick.
Great as always 🙏 Thank you so much
I quite like the blank row 💫 Great Video
This is great! To be honest never paid any attention to the "broken lines". Just avoided many-many relationships and never worked with composite models that much :).
I guess the smart use of "Dual Mode" for the objects on the link between the continents is the way to go in this kind of models to be sure the blank rows shows when it needs to?
Thank you for the wonderful explanation 🙂
I appreciate the blank row, and I know why I have the blank row in my data. I just wish there was an easy way to collapse it into another category on my dimension table when I choose. Otherwise my connection to the data source for the dimension will also have to have to append an anti-join to the fact table to add the missing rows to the dimension table source. Easy enough with SQL, but in the real world data isn't perfect, and executives with room temp IQs don't understand "blank".
Preat good! Thank you so much for you suport.
thanks
Great video from great Man
Hello,
Is it possible to put measures in rows of matrix but in row will be also other variable and measures will be above this variable? Thanks in advance
You can do that in Excel but not in Power BI - a possible workaround is moving measures to a calculation group or create a measure that chooses the actual calculation based on a slicer selection.
@@SQLBI Thank you for your answer ;)
@@mariuszkrzemien6576 Well, for Matrix Visual there is a switch in "Values/Options" Section of properties. Where you can turn on "Switch values to rows". Should do the trick.
@@KefasoNaib Yes, it does. I am wondering how comes SQLBI missed that unless we are wrong
Thanks! 🙏