Forum Discussion
Helper ICombo Chart in Power BI with multiple Y axis
- FYI reported this on ideas forum and got this answer.
“In your scenario, you need to change the X-Axis type as Categorical, then the sort menu is available if the X axis has date or number values. “ Thank You So Much Seward. It works!!!
Regards,
Shahin K
Solution SageI think you may have found a BUG with the new Sort Capability they recently rolled out. I have to try to find an old powerbi install to test it.
When you have an integer series on the axis it does not let you sort! Also would not sort with Date[Date] on the axis I even tried specifying Sort by and choosing the date field. It did work with a text column in the date table that had Sort By used to specify the sort (in this case sort by [Date] column.
As a work around I added a "Last N Days" from NOW to my date table, added a second column for [Last N Days TXT] using FORMAT([Last N Days,"General Number") and set a visual filter on that to limit chart to last 21 days and the used the actual date on the axis. Could then sort just fine.
See this sample PBIX I modified form another solution I recently helped out on as an example.
Solution Sage“In your scenario, you need to change the X-Axis type as Categorical, then the sort menu is available if the X axis has date or number values. “
ShahinkmajeedThank You So Much Seward. It works!!!
Regards,
Shahin K