cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Avishek07
Frequent Visitor

Dynamic X-axis dimension without Bookmark and Field Parameters

Hi All, I am currently in the need to create a dynamic X-axis (dimension) without making use of field parameters (Live connection) and bookmarks (too many bookmarks already present). I have created a static table with 4 values and I am trying to create a switch statement as below... but for some reason it is not working:

 

Dynamic Dim = VAR sel =
    SELECTEDVALUE ( 'Select Dimension Table'[Dimension] )
RETURN
    SWITCH (
        sel,
        "Category", Orders[Category],
        "Sub-Category", Orders[Sub-Category],
        "Region", Orders[Region],
        "Segment", Orders[Segment]
    )
 
Can some1 please help me to get this done keeping in mind the restrictions above.
3 REPLIES 3
Avishekd1991
New Member

I need to switch between dimensions..as clearly mentioned above..x- axis should depict category or sub category or region etc based on my slicer selection...and I am guessing that in no way can be defined as a measure...

 

You can use Field Parameters to swap dimension columns dynamically.

lbendlin
Super User
Super User

There's no such thing as a dynamic column  - well there is, but it's called a measure.

 

Please explain in more detail what you are trying to achieve.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors