Power BI: multiple dimensions on chart x-axis and in tables - 2 of a series of 5 on the DAX TREATAS() function
Art Tennick
![Art Tennick]()
Art Tennick
??3 US Patents in BI??technical editor 4 Packt Power BI books??author 20 computer books??Power BI??Analysis Services??Python/R in Power BI??Paginated??MDX DAX SQL Python R TMDL??ex-university SQL lecturer??35 years in BI
This extends my previous article on letting user choose the x-axis and y-axis in a chart. All the information, links, and DAX you need is there. This pbix does have a little extra DAX to define the sort order for the attributes on the x-axis:
Attribute Sort Column = SWITCH('AXIS SLICER'[Axis], "Country", "Co" & [Attribute], "Category", "Ca" & [Attribute], "Year", "Y" & [Attribute])
3 links:
uses Adventure Works DW, so feel free to adapt pbix.
Senior Business Data Analyst - Contractor Hstep | Py/PBI/ML/SQL/Tableau
4 年Great Article, thank you for sharing! The link to PBI file is expired, could you pls share it with me [email protected]
Business Intelligence Analyst/Developer - BI & Data Predictive Analytic, Big Data
5 年Cool trick!
Technical and Team Leader | Solution Architect | Data & Analytics
7 年Rodrigo Cruz