Forum Discussion

Mahima's avatar
Mahima
New Member
4 years ago

Customize X axis range for clustered column chart

Hello Power BI Users!!

 

I am working on my first Power BI project and I am stuck with x axis value ranges.

 

I have added a clustered column chart and the x axis has Fiscal year and Y axis shows a percentage value for two parameters.

I wish to apply range to x axis according to a condition as mentioned below:

 

Start: where y axis parameters have some value

End: where Y axis parameters have some value + 2 years

 

To put in other words, I would want to set range to X axis based on various conditions.

 

Please help me here as I have read many posts and nothing is working out.

 

Thanks,

Mahima

Need Help
Tips and Tricks

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Mahima ,

     

    Can you please share a mockup data or sample of your PBIX file and expected result. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Mahima,

    Any update on this? Can you please share a pbix or some dummy data that keep raw data structure with expected results? They will help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng