The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |