Skip to main content
cancel
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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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.