Visual loading issues

[adsa]

Hi All,

I previously posted a question about Ranking here Rank Masking and it works well.

The issue i’m now facing is when implementing this logic into my Main model, i’m finding the visual takes a while to load.

The culprit measure is the filter measure at the visual level:

Vis Rank = VAR Result =
    IF(
         [All Product Rank]>=[Selected Product Rank] - [Parameter Value]
            && [All Product Rank]<=[Selected Product Rank] + [Parameter Value],
        1,
        0
    )
RETURN
    Result

Is there a better way to handle this so the visual loads faster?

Thanks in advance
Updated Practice.rar (1.1 MB)

[AntrikshSharma]

@adsa Measure in Filter Pane have a high penalty so try to avoid that.

Performance penalty of Measures in Filters Pane in Power BI

You don’t need to use that measure in the Filter Pane instead of that drop it into matrix and just reduce the width of the column or use a transparent color to hide the values.

Method 1 - Rename column and make font white

Method 2 - Rename column and make font transparent

[adsa]

@AntrikshSharma Thanks for this.

I will give this a try on my main file. Can confirm this works on the test file.