Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm trying to make a visualization in which we can see the data by month and not by days (axis x), but i can't change my data hirarchy. Do you know why ?
There's a few things I can think of -
Is the data type date? (If not, then it won't have a heirarchy unless you've set one up yourself)
Have you got a date table that has a relationship? If you want to use the date heirarchy, you will need to use the date from your date table.
Hello,
Yes, the data type is date
Also, yes i have a date table that has a relationship. If i use the date from my date table, the visualization look like this. The data is still by days and not by month (axis x) and i can't change my data hirarchy.
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |