Forum Discussion

louisquinet's avatar
louisquinet
Helper II
2 years ago
Solved

Variable range X axis *1.05 with Switch()

Hello

I would like that my x range is always between 0 and 1.05 the highest value so that you can see better see the points on my chatter chart. Bellow you can see the example about what I'm talking. As you can see the point is al the way in the corner so I would like to add a margin of 5%. The complicated thing is that my X axis can be 'net unit price' and 'maintenance price'

 

I tried this as measure but, nothing happens when I put this in the X axis range:

 

Has anyone an idea about what I do wrong? Or another idea to accomplish this?

Thank you in advance

Louis

 

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Daniel29195 and louisquinet ,

     

    Daniel, thank you for your thoughtful concern regarding Louis. It’s great to see such a supportive community here. 

     

    And Louis, I appreciate your patience. After carefully reviewing your query, I recommend the following solution:

    You may learn about a feature called Field Parameters. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in. Please refer to the below link for more details:

    Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

     

    Example:

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

2 Replies

  • Daniel29195's avatar
    Daniel29195
    Community Champion

    louisquinet 

     

     

    can you please provide a sample of the file you working on ,  with this problem and share it via google drive ? 

     

     

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Daniel29195 and louisquinet ,

     

    Daniel, thank you for your thoughtful concern regarding Louis. It’s great to see such a supportive community here. 

     

    And Louis, I appreciate your patience. After carefully reviewing your query, I recommend the following solution:

    You may learn about a feature called Field Parameters. Field parameters allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your report readers explore and customize the analysis of the report by selecting the different measures or dimensions they're interested in. Please refer to the below link for more details:

    Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

     

    Example:

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.