Shows data partially based on percentage selected in slicer

[Farrah24]

Hi!

So i hava data of app index per day. I want to show it in graph, consist of app index in y-axis and elapsed day in x-axis. 

I want to show the data based on the selected data percentage in slicer. For example, I have in total 9039 data. if i select 10% they will only show 10% of the data from the back which is data 8135 to 9039 (Total 904 data showed). How do i make it on dax?

Thanks in advance!

[Anonymous · Accepted solution]

Hi @Farrah24 ,

Here I suggest you to create a measure and add this measure as a visual level filter in your line chart. In my sample, I create a percentage slicer by what if parameter.

Filter = 
VAR _PERCENTAGE =
    DIVIDE ( SELECTEDVALUE ( Percentage[Percentage] ), 100 )
VAR _MAXINDEX =
    CALCULATE ( MAX ( 'Table'[Index] ), ALL ( 'Table' ) )
VAR _ROUNDUP =
    ROUNDUP ( _MAXINDEX * _PERCENTAGE, 0 )
VAR _RESULT =
    IF ( MAX ( 'Table'[Index] ) >= _MAXINDEX - _ROUNDUP, 1, 0 )
RETURN
   _RESULT

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Farrah24 , One you mutiple measure by 10%

[Measure]*[Parameter value]/100

or use this parameter with pareto logic, refer my filter example at end

Continue to explore Power BI Window function- Pareto Analysis, 80% of sales, Order by on Measure: https://www.youtube.com/watch?v=UVxiLc_AzSs

This mean 10% contribution