Dynamically change chart axis in Power BI

 https://www.youtube.com/watch?v=n-OWNaCUU0o

Steps:

Duplicate Product table and name new table ProductUnpivot

Select Product and Color in new table; make sure they are the same type; Unpivot. Now you have ProductKey, Attribute and Value columns in the new table.

1 to many relationship between Product and ProductUnivot

Create slicer on ProductUnpivot[Attribute] - values are Product and Color

Bar chart with ProductUnpivot[Value]

Create new measure Dynamic Sales = 

CALCULATE([Sales], 

CROSSFILTER(Product[ProductKey], ProductUnpivot[ProductKey]

)

Use CROSSFILTER instead of changing relationship Cross Filter Direction to BOTH



Comments

Post a Comment

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX

https://www.sqlbi.com/blog/marco/2011/03/08/difference-between-distinct-and-values-in-dax/   Example: If a  FACT table contains values that do not exist in a related DIMENSION table, a BLANK row is automatically added to the DIMENSION table. This DIMENSION row with the BLANK value will join to any FACT row where the column value does not exist in the DIMENSION. DISTINCT will NOT include the BLANK column in the DIMENSION. VALUES will include the BLANK column in the DIMENSION.
Read more