Forum Discussion
How to fixed X-Axis after filtered data?
- 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
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
Hello Frank
Yes ‘ I mean x-Axis data labels are static.