Forum Discussion
Matricial dot plot
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
I have 3 columns that matter :
ID_Post ; Creation_Hour ; Posting_Author
Every line is for a different post. I can have several hours for a single person (several persons for one hour is unlikely but theoretically possible)
For example, I would have
1 ; 1:00:00 ; John
2 ; 3:00:00 ; Jane
3 ; 1:00:00 ; June
4 ; 2:00:00 ; June
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
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
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