dynamic dimension

Hey Emmy66 

here is a pbix file that contains sample data, there is a report page called "dynamic axis content".

The Table visual and the Stacked bar chart visual are using the column "Axis Label" from the table "Axis content".

The Slicer is using the column "Slicer".

The table is based on a DAX statement, which means whenever the underlying data model will be refreshed the content of the table will be updated as well.

The table FactOnlineSales contains a measure called "dynamic axis measure" this measure maps the axis content to the "real" columns, the "real" tables in your data model.

There is another maybe the goriest detail that makes this approach work. This detail is called lazy evaluation. The evaluation of a condition in DAX expressions is immediately stopped when the whole condition (ANDs and ORs are used) can not become true anymore or the whole expression already is true.

When the slicer selection results in Product Category, the variable checkContinent equals zero. This means that the 1st part of the condition for the continent filter part already stops the evaluation.
The downside of this approach is that each value of the slicer needs its own filter expression.

Hopefully, this provides what you are looking for, at least provides some new ideas.

Regards,

Tom