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 All,
1. The first issue is the months are sorted but not the year.
2. The Month are repeated and not cumulatively summing up.
COS = CALCULATE(SUM(Project[Size (MWp)]),FILTER(ALL(Project),Project[COD] <= MAX(Project[COD])))
How is your data look like? I mean, Date with Time Stamp or just Date?
Second, you can set OFF Concatenate labels under X-Axis option. So, You can see year wise on X-axis. If data on X-axis shows year, just drill down to Months.
Hi
I used the below formula
COD Month = DATE(YEAR(Project[COD]),MONTH(Project[COD]),1)
I put this COD Month in Axis now.
and now it works fine but the issue is it shows from largest to smallest. Eg from Jan 19..Dec 18 instead of Dec 18 Jan 19
try to sort again.
OR
do one thing, go to query editor, create a custom column for the month like if [Month] = January then 1 etc.. once done, come back to the report then try to sort the COD by newly created Custom column.
It says that the column has been sorted directly or indirectly by another column.
did you tried to create a conditional column in query editor as i mentioned above?
Not working
If possible can you show your data in query editor as well as on report?
Please see my thread.
The COD field was a date field which was in this format initially dd/mm/yyyy but I chananged it to Month Year
http://community.powerbi.com/t5/Desktop/Need-help-in-formula/m-p/374046#M169835
The date was scrambled, can you post the sample data here? So, I can give you the proper solution.
Hi
The COS is a measure which has the formula which I posted long back. Somehow the COD is in descending order. When I transform it in bar chart, it starts from Jan 19, Dec 2018 etc...
Please find the below table.
Hi,
Looks like you use sort order by COS in Chart. Change Sort Order.
No It is sorted by COD Month
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 |
---|---|
98 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |