Forum Discussion

Avishek07's avatar
Avishek07
Frequent Visitor
3 years ago

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    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.

  • Avishekd1991's avatar
    Avishekd1991
    New Member
    3 years ago

    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...

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      You can use Field Parameters to swap dimension columns dynamically.