Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.