Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have one column with the date and other with the value for this date (it corresponds to different measurements). I want to do a graph that shows each point and in the x axis the correspondent day. But when I put the day in the axis appears the cumulative value per day....
Index Date_my Value
0 | 01-01-2016 | 1 |
1 | 01-01-2016 | 2 |
2 | 01-01-2016 | 1 |
3 | 02-01-2016 | 3 |
4 | 02-01-2016 | 1 |
5 | 02-01-2016 | 3 |
6 | 03-01-2016 | 5 |
7 | 03-01-2016 | 1 |
8 | 03-01-2016 | 2 |
There is any way to display the information that appear in the first graph but in the axis appear the day?
Hi, @Sea_and_Anne
In your scenario, if you want to display each data point in one day and set the date column as X-axis, it cannot be achieved in a area chart. To work around this, I would suggest you select clustered column chart.
Add a calculated column to table:
Column 2 = COUNTROWS(FILTER(Graph,EARLIER(Graph[Index])<=Graph[Index]&&EARLIER(Graph[Date])=Graph[Date]))
Create column chart as below:
Best regards,
Yuliana Gu
Hi @Sea_and_Anne, I do not understand what you want the result to look like. Please could you describe it much more exactly?
Regards.
Pavel
Sure!
Sorry , i will try to be more clear.
So, my table have plenty register per day, that correspond to different measures during the day.
I want a graph that shows the diferent points during the day, as the follow picture:
but in the X axis, i want to show the correspondent day of the measure...
In excel if i select the data and insert a area graph i can select the Date as the data of the horizonatal axis label ....and works well..
but i don't know how do this on power bi ...
😞
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |