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 like to combine two tables of data into one bar chart.
this this the first data table:
Forecast data | Amount | Expecteddate | DateofForecast | Product | |||
80 | 1-6-2016 | 27-4-2016 | Red | ||||
90 | 1-6-2016 | 4-5-2016 | Red | ||||
95 | 1-6-2016 | 11-5-2016 | Red | ||||
98 | 1-6-2016 | 18-5-2016 | Red | ||||
100 | 1-6-2016 | 25-5-2016 | Red | ||||
90 | 5-6-2016 | 1-5-2016 | Green | ||||
95 | 5-6-2016 | 8-5-2016 | Green | ||||
100 | 5-6-2016 | 15-5-2016 | Green | ||||
108 | 5-6-2016 | 22-5-2016 | Green | ||||
110 | 5-6-2016 | 29-5-2016 | Green |
This is the second datatable.
Amount | Expecteddate | DateofForecast | Product | ||||
actuals data | 101 | 1-6-2016 | 1-6-2016 | Red | |||
112 | 5-6-2016 | 5-6-2016 | Green |
The bar chart could look like this
The bars should be clustered by expecteddate and product
The last bar of the product (= actuals) may be different color.
I like to have this analysis over a month period for example.
Any ideaS how to do this?
JohnD2
Solved! Go to Solution.
Hi sridevi,
In your scenario, you should combine the two tables into a single one first.
uniontable = UNION(ADDCOLUMNS(Actual,"Actuals","actual forecast"),ADDCOLUMNS(Forcecast,"Actuals","Forcecast forecast"))
To distinguish the bar color between actual value and forcecast value, you can add anextra legend in the chart.
If you have any question, please feel free to ask.
Best regards,
Yuliana Gu
Hi sridevi,
In your scenario, you should combine the two tables into a single one first.
uniontable = UNION(ADDCOLUMNS(Actual,"Actuals","actual forecast"),ADDCOLUMNS(Forcecast,"Actuals","Forcecast forecast"))
To distinguish the bar color between actual value and forcecast value, you can add anextra legend in the chart.
If you have any question, please feel free to ask.
Best regards,
Yuliana Gu
Hi John,
Please see attached file here for your solution.
You have to append your Actuals Table onto the Forecast Table and You can load this query into the PowerBI and Create Bar Chart visual with data labels on to visualize your output.
Thanks & Regards,
Bhavesh
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |