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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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] )
    SWITCH (
        "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.
New Member

I need to switch between 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.

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.