Forum Discussion

Ajithrjaa's avatar
Ajithrjaa
Frequent Visitor
2 years ago
Solved

Use Case Cenario

Hi All, I have some use case cenario. Link : https://drive.google.com/file/d/1BKuC0jXpJcEXxG0sse-3lY0RbHEsqfc2/view?usp=sharing I have table Visual Contains a Columns Fiscal Year, Net Fees, Ran...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi Ajithrjaa - create a below measure for max month number and add it to the table chart.

     

    MaxMonthNumber =
    CALCULATE(
        MAX('Table'[Rank]),
        FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))
    )
     

     

     

    created calculated column as below for filter applied

    IsVisible =
    IF(
        'Table'[Rank] <=
            CALCULATE(
                MAX('Table'[Rank]),
                FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))
            ),
        1,
        0
    )
     

     

     

    Hope it helps

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi Ajithrjaa - create a below measure for max month number and add it to the table chart.

 

MaxMonthNumber =
CALCULATE(
    MAX('Table'[Rank]),
    FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))
)
 

 

 

created calculated column as below for filter applied

IsVisible =
IF(
    'Table'[Rank] <=
        CALCULATE(
            MAX('Table'[Rank]),
            FILTER('Table', 'Table'[Fiscal Year] = MAX('Table'[Fiscal Year]))
        ),
    1,
    0
)
 

 

 

Hope it helps

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!