Forum Discussion

mohsen_rem23's avatar
mohsen_rem23
New Member
8 years ago
Solved

How to fixed X-Axis after filtered data?

Hello Everebody As per below screenshot I'm going to fixed X-Axis data after filtered .   The X-Axis's data is time.
  • v-frfei-msft's avatar
    8 years ago

    Hi mohsen_rem23,

     

    Could you please tell me what do you want? Keeping the X-axis data labels static or make the bar width  static ? If we want to keep the X-axis data labels static, we can take the following steps to meet your requirement.

     

    1. Create a new table based on the column that we want to use on the X-axis. And create a measure as below.

     

    Measure = IF(ISNUMBER(CALCULATE(SUM(Table1[sale]),ALL('Table'[Time]))),0,0)

     

    2. Add the measure to the visual, then we can get the result as below.

     

     

    For more details, please check the pbix as attached.

     

    https://www.dropbox.com/s/2h4ewp0qbrr7m1y/How%20to%20X.pbix?dl=0

     

    Regards,

    Frank