How to Hide Last 4 Quarters data in X axis Dynamically

Hi rajendraongole1 ,

I loaded your data and tried to simulate the expected output.  

The solution assumes that you will be showing all the previous quarter compared with the max value of the quater year in the data. 

So this will not work based on any filter on date, if you have.

Paste the code in the powerquery

let
    Source = Excel.Workbook(File.Contents("C:\PowerBICommunity\QuarterData.xlsx"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Year Quarter", type text}, {"Amount", Int64.Type}}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Changed Type", "Year Quarter", "Year Quarter - Copy"),
    #"Split Column by Delimiter" = Table.SplitColumn(#"Duplicated Column", "Year Quarter - Copy", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"Year Quarter - Copy.1", "Year Quarter - Copy.2"}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Year Quarter - Copy.1", Int64.Type}, {"Year Quarter - Copy.2", Int64.Type}}),
    #"Renamed Columns" = Table.RenameColumns(#"Changed Type1",{{"Year Quarter - Copy.1", "Base Year"}}),
    #"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns",{{"Year Quarter - Copy.2",  Int64.Type}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Changed Type2",{{"Year Quarter - Copy.2", "Base QUarter"}}),
    GetMax = List.Max(#"Renamed Columns1"[Year Quarter]),
    LoadMax = Table.AddColumn(#"Renamed Columns1","max",each GetMax),
    #"Split Column by Delimiter1" = Table.SplitColumn(LoadMax, "max", Splitter.SplitTextByDelimiter("-", QuoteStyle.Csv), {"max.1", "max.2"}),
    #"Changed Type3" = Table.TransformColumnTypes(#"Split Column by Delimiter1",{{"max.1", Int64.Type}, {"max.2", Int64.Type}}),
    #"Renamed Columns2" = Table.RenameColumns(#"Changed Type3",{{"max.1", "MaxYear"}, {"max.2", "Max Quarter"}}),
    #"Added Conditional Column" = Table.AddColumn(#"Renamed Columns2", "Custom", each if [Base Year] >= [MaxYear] then 0 else if [Base QUarter] <= [Max Quarter] then 1 else 0)
in
    #"Added Conditional Column"

Change the Souce line pointing to your data source and file name. 

What this does is, after loading the base data it finds the maximum year quarter combination and populates the same in a new column.

The original YearQuarter and the new column Max YearQuarter are split into year and quarter.

Then add a column comparing the OriginalYear with MaxYear and OriginalQuarter with MaxQuarter and set as 1 or 0.

The logic applied is if the OriginalYear is Equal to the MaxYear then set it as 0.- - to indicate not to show.

If the OriginalYear is less than the MaxYear then if the OrginalQaurter is less than equal to the MaxQuarter set as 1 -  to show.

Otherwise 0 - not to show.

The visual as per orginal data which has 2019-4 as the last YearQuarter

With base data upto 2019-4After adding 2020-1 to data

The chart 1 is with the data provided by show and does not show 2019 quaerters

The chart2 is with adding 2020-1 data.  Shows only quarter-1 data for all previous years.

Is this the expectation.

Try it out and let me know.

Cheers

CheenuSing