Forum Discussion
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.
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
3 Replies
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.
Hi there - I am having this exact problem, but your dropbox link no longer works.
I'm not understanding exactly how to implement the solution.
I have a performance ranking from 1-4 for a company, and for a sub-set of managers they have only received the ranking 3-4 (not 1-2).
But the x-axis shows only 3-4.
Any additional assistance would be greatly appreciated!
