Forum Discussion
Solved
Pivot Chart as in Excel
Good afternoon, I'm trying to make a Pivot Chart like this one with Power BI : I tried with Power BI but I've got this king of graphic : So I have the date and the number a...
Hi JonathanJohns,
If you want to achieve in Power BI similar to the screenshot below, follow this:
- In Fields pane -> Axis, place you Date first then Number below that.
- From the upper left of your column chart, click the icon that says Expand All Down One Level in the Hierarchy until your desired depth of hierarchy is shown.
- In Formatting Pane -> X-Axis,
- change Type to Categorical
- Turn off Concatenate labels
- And then sort the columns by value then Sort by Date Number (or whatever fields you have in X axis). Turning off label concatenation does not take effect until columns are sorty by a value first then sorty by category (it's probably a bug).
Hi JonathanJohns,
If you want to achieve in Power BI similar to the screenshot below, follow this:
- In Fields pane -> Axis, place you Date first then Number below that.
- From the upper left of your column chart, click the icon that says Expand All Down One Level in the Hierarchy until your desired depth of hierarchy is shown.
- In Formatting Pane -> X-Axis,
- change Type to Categorical
- Turn off Concatenate labels
- And then sort the columns by value then Sort by Date Number (or whatever fields you have in X axis). Turning off label concatenation does not take effect until columns are sorty by a value first then sorty by category (it's probably a bug).
Thank you for your answers. The way how you make danextian works well with my data !