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.
Hi everyone
Let say I have a table like this:
Date | Value |
10/2/2019 | 1 |
10/2/2019 | 3 |
10/3/2019 | 4 |
10/4/2019 | 3 |
10/4/2019 | 2 |
10/4/2019 | 1 |
10/5/2019 | 5 |
10/5/2019 | 6 |
10/6/2019 | 4 |
I want to make a line chart that showing sum of value of every date, but instead of showing date at the x-axis, I want to show the day of the week like Monday, Tuesday, Wednesday, and so on.
I am using Power BI May 2019 edition, and SSAS as data source. Some features isn't available when I am using SSAS as source. Please help, thank you
Solved! Go to Solution.
Hi @yohandy112 ,
Below steps will help:
> Go to Query Editor
> Duplicate Date Column
> Make sure it is Date Format
> Right Click on Column > Transform > Day > Name of Day
> Close & Apply
> Create new Bar chart visual
> Use new Date column as Axis
> Use Value Column as Value (Should automatically be aggregated as SUM. IF not, right click on Value field)
>Done
Let me know is any issue
Cheers
Rob
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @yohandy112 ,
Below steps will help:
> Go to Query Editor
> Duplicate Date Column
> Make sure it is Date Format
> Right Click on Column > Transform > Day > Name of Day
> Close & Apply
> Create new Bar chart visual
> Use new Date column as Axis
> Use Value Column as Value (Should automatically be aggregated as SUM. IF not, right click on Value field)
>Done
Let me know is any issue
Cheers
Rob
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |