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,
I have a data and want to plot the line chart with year and quarter on x-axis.
There is a column called "date".
I create a measure and want to plot this measure.
REALWANT = VAR MINYR = CALCULATE(MIN(dt[date].[Year]),ALLEXCEPT(dt,dt[Group])) VAR MINQR = CALCULATE(MIN(dt[date].[QuarterNo]),ALLEXCEPT(dt,dt[Group])) VAR NEW= CALCULATE(SUM(dt[Numbers]), FILTER(ALLEXCEPT(dt,dt[Group]), dt[date].[Year] = MINYR && dt[date].[QuarterNo] = MINQR)) VAR WANTDenominator = IF(MAX(dt[Numbers]) = Blank(), Blank(), [NEW]) VAR WANTNominator = CALCULATE(SUM(dt[Numbers]), ALLEXCEPT(dt,dt[Group],dt[date].[Year],dt[date].[QuarterNo])) Return WANTNominator/WANTDenominator
Now, I click on the Line Chart in the report tab and put this measure on y-axis, Group on legend, and date hierarchy (only year and quarter) on x-axis.
However, the line plot showd inappropriately. On the x-axis, it only showed year so that it automatically added up measure for all quarters in each year by group.
Even I create a new column as below:
yq = dt[date].[Year] & dt[date].[QuarterNo]
And plot again, the x-axis on plot displays weired. It did not display as order.
How can I figure out this?
Also, is it possible to create a filter for Group and when I filter values in that, the plot will change. I think I need to add something like SELECTEDVALUE. Not sure.
Solved! Go to Solution.
Hi @PeterChen ,
Based on my test, I got this output, Then what is your excepted result?
Hi @PeterChen ,
Based on my test, I got this output, Then what is your excepted result?
@v-frfei-msft wrote:Hi @PeterChen ,
Based on my test, I got this output, Then what is your excepted result?
The order is weird if I create a new column with year and quarter.
Moreover, if I plot like your way using original date column and select hierarchy for year and quarter, the x-axis on line chart only shows year rather year and quarter.
In addition, if I copy your plot and then change the axis, legend, and values to my data, it works. Not sure why it works in copy and paste....
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |