Forum Discussion
How to use the entry with data on matrixes
Super UserHi,
The visual you are creating will make sense only when you select a day in the Date slicer. This is because the categories that people fall into will/may vary day on day. So you should create a Calendar Table with a relationship (Many to One and Single) from the Date column of your Data Table to the Date column of the Calendar Table. Create a slicer from the Date column of the Calendar Table and select a certain date.
Hope this helps.
Hey, thank you for stopping by!
That suggestion is actually what I already have on my main Power BI sheet that has more data from more months. It works well if I want to show a daily status, but my client also wants to see a monthly report, quarterly report, or just any range in particular, so I have to keep the slider with the range of dates, while also making sure the data is relevant and not the mistake I'm making above.
If a matrix won't work for what I'm looking for, do you have any similar visuals or methods in mind? They could come from an outside source, it doesn't really matter much.