Forum Discussion

Océane's avatar
Océane
Frequent Visitor
8 years ago
Solved

Matricial dot plot

Hi,   I was wondering if it is possible to create a sort of matricial dot plot (I'm not even sure than means something ;) )   Concretely, I have persons who send messages at certain hours. I woul...
Need Help
  • alexei7's avatar
    alexei7
    8 years ago

    Hi Océane,

     

    Yep I've this working for me.

     

    Firstly create a measure - please change "Table1" to whatever your table is called:

     

    Measure = if(COUNTROWS(Table1)>0,"X","") 

    Now in Power BI select the "Matrix" visualisation.

    Put "Creation_Hour" as the row, "Posting_Author" as the column and the new measure as your "Values".

     

    Hope that helps,

    Alex

     

Océane's avatar
Océane
Frequent Visitor
8 years ago

Thank you!

 

Actually, I was hoping for something with dots,  more like a dot plot but with hours in Y axis instead of just number for scale.

 

Do you think that possible?

 

But if not, your solution works :)

 

Océane

alexei7's avatar
alexei7
Continued Contributor
8 years ago

I've had a look (and also at some custom visuals), but I can't see a way of doing what you're trying!

 

Maybe someone else will know a way.

 

Thanks,

Alex