Reorder overlapping line charts in Power BI (New 2021)
Line charts with series must overlap somehow but often you want to choose which is in front, now with new functionality since the Oct release you can do that, it requires a combination of Power Query, modelling and visual amendments but I cover it all in a 4 min video.
1. In Power Query add an index column from 2, then a conditional column saying to mark 1 for the preferred line series , then index otherwise
2. Use sort by column to sort your series col by the new conditional column
3. In your line chart sort the legend, even if you don't have a legend this still works well
Видео Reorder overlapping line charts in Power BI (New 2021) канала David Benaim
1. In Power Query add an index column from 2, then a conditional column saying to mark 1 for the preferred line series , then index otherwise
2. Use sort by column to sort your series col by the new conditional column
3. In your line chart sort the legend, even if you don't have a legend this still works well
Видео Reorder overlapping line charts in Power BI (New 2021) канала David Benaim
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Look up geo stats & map it on Excel](https://i.ytimg.com/vi/p0qWiyQMcow/default.jpg)
![Detect existing Excel errors with data validation layering](https://i.ytimg.com/vi/DzjxATX-xQU/default.jpg)
![Excel's Pareto chart & its unexpected benefits](https://i.ytimg.com/vi/dSObLiX4yVI/default.jpg)
![Unpivot in Google Sheets with FLATTEN: Column pairs, auto expand++](https://i.ytimg.com/vi/lCB6aXcQdV4/default.jpg)
![Stacked infographics in Excel & PowerPoint](https://i.ytimg.com/vi/-3HkHqEogQk/default.jpg)
![Excel copilot vs similar features (free or cheap)](https://i.ytimg.com/vi/uNElwRhVh6A/default.jpg)
![Advanced Sorting in Excel: Multi level, horizontal, with formula](https://i.ytimg.com/vi/gUbEnDqJdTE/default.jpg)
![Dynamic Arrays 5 best & 5 worst features for Excel](https://i.ytimg.com/vi/r4tD5PioqMA/default.jpg)
![Fix cASiNg extra spaces & similar text NEW in #Excel online](https://i.ytimg.com/vi/O-AKSXIHR8I/default.jpg)
![New Excel Navigation Pane + 26 Navigation tricks](https://i.ytimg.com/vi/Krg-Ho0Fwbw/default.jpg)
![Excel vs G sheets for remote working webinar](https://i.ytimg.com/vi/4CtEHm6eUt8/default.jpg)
![Excel hash: LAMBDA, EVEN, power query, & “actors” in a murder mystery](https://i.ytimg.com/vi/lNk8j_ci6e8/default.jpg)
![Fixing DAX issues with wrapper functions](https://i.ytimg.com/vi/yIepR4XOXPA/default.jpg)
![30+ formula & # format shortcuts touring Cambodia with Fred Le Guen](https://i.ytimg.com/vi/0Jq0W7Fmjkw/default.jpg)
![Fill formulas but keep formats #Excel #excelshortcuts #excelformula #tutorial](https://i.ytimg.com/vi/mUi3jx-xKMw/default.jpg)
![17 Smart / AI tools in Canva](https://i.ytimg.com/vi/_aiCh6G8c0s/default.jpg)
![PQ Choose folderpath from Excel](https://i.ytimg.com/vi/UAvsr06yHGU/default.jpg)
![Sum super fast in #Excel with alt = on multiple cells #excelformula #exceltips](https://i.ytimg.com/vi/OS6mRoIQh7M/default.jpg)
![Searchable/autocomplete drop downs in Excel + TEXTSPLIT: No more dependent lists](https://i.ytimg.com/vi/baJNifZZC-I/default.jpg)
![Excel: Drop down lists & validation to pre-empt errors](https://i.ytimg.com/vi/hcKkIXLzdMs/default.jpg)