In Excel, I can create a Chart with Program and Commodity shown on one chart in a format that is easier to understand instead of Concatenating like PowerBI does when using drill down.
Here I can click +/- to drill down to Program Level and Commodity level (with Program name in the X-axis also). How can I create similar chart in PowerBI.
Thank you so much!
@lotus22 , Try like. Take program and Community on-axis and sort on them. Use expand drill icon, The reverse square Y icon. Switch off concatenate labels
@lotus22 , Try like. Take program and Community on-axis and sort on them. Use expand drill icon, The reverse square Y icon. Switch off concatenate labels
Helpful resources
Experience what’s next for Power BI
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
The largest Power BI virtual conference
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
