Solved: Differences between Table and Matrix Visualization

admin_xlsior · ‎05-08-2019

Hi guys,

What is the differences between Table Visual and Matrix Visual, besides Matrix are able to put data column wise like pivot table ?

If without sample of the data or take a look at the measure, can someone advise why with the same data, I have 2 different result, as below :

As in above pict, the value (last column) is only in row October 2015 - External and November 2015 - external.

But when I changed (instantly) to Matrix visualization, suddenly I have value for August 2015 and September 2015 while November 2015 is missing :

The value itself is a measure.

Is with the same data and measure, Table Visualization and Matrix possible to have this kind of behaviour ?

Thanks,

admin_xlsior · ‎05-14-2019

Hi thanks for your kind reply.

I resolved this however, but just for information, this is the website I try to use before. It is realy great blog, btw.

https://blog.gbrueckl.at/2014/12/events-in-progress-for-time-periods-in-dax/

.. and my error is resolved because it realy needs a free no-relationship Date dimension to use. I just create new Date dimension and problem solved.

View solution in original post

parry2k · ‎05-08-2019

@admin_xlsior Can you share measure expression? this seems really odd. if you can share sample data with relationship diagram, will help to investigate it further.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.