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, everybody!
I'd like to know if is possible to do a bar chart in Power BI like the image below.
I have a bar whose data is the cumulative of the year 2016 and then I have others bars whose data are the sum of each month of 2017. Is there anyway to freeze the first bar (2016) on the bar chart?
Best regards,
Marcela.
Solved! Go to Solution.
Hi @marcelammelo,
We need to create a summarized for year 2016 to return total value for all months in year 2016, then union this table with the table which has month values.
Assume the fact data likes below:
You can create another table with DAX:
Table = UNION(SUMMARIZE('Table1','Table1'[Year],"Amount",SUM('Table1'[Amount])),SUMMARIZE('Table1','Table1'[MonthName],"Amount",SUM('Table1'[Amount])))
Then create a column chart, drag Year column to Axis, Amount to Values. For details, you can download the attached pbix file to have a look.
Best Regards,
QiuyunYu
Hi @marcelammelo,
We need to create a summarized for year 2016 to return total value for all months in year 2016, then union this table with the table which has month values.
Assume the fact data likes below:
You can create another table with DAX:
Table = UNION(SUMMARIZE('Table1','Table1'[Year],"Amount",SUM('Table1'[Amount])),SUMMARIZE('Table1','Table1'[MonthName],"Amount",SUM('Table1'[Amount])))
Then create a column chart, drag Year column to Axis, Amount to Values. For details, you can download the attached pbix file to have a look.
Best Regards,
QiuyunYu
Hello, @v-qiuyu-msft!
That's amazing! You're awesome!
Thanks a lot for the solution and example. You made it easier than I could imagine.
You really helped me.
Regards,
Marcela.
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |