Hi, my client requested to create a chart that combine stacked and column chart together.
From my research, most of the solution only say "You can't"
also, there are custom visual from 3rd party company, which I can't use due to security reason
I mean, Are there any workaround to get into that chart, i.,e. manipulating the data so the axis can be adjusted (there are tips in excel to manipulating the axis, but i am not sure how to do it in powerBI) ?
Solved! Go to Solution.
I have put together this solution that uses measures and is not depending on the data structure to be in just one table if it's still interesting.
I followed this and my X axis are United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual - even with turning concat off. I cannot get Country on a seperate line.
I followed this but when I drill through I get United States Forecast, United States Actual, United Kingdom Forecast, United Kingdom Actual. I don't get the Country on a seperate line for X axis; even with turning concat off.
Click here to read more about the November 2022 updates!
Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.
This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.