Percentile based on sumarised columns, filterd by slicer?

[jonathanb]

Hi I am new to Power BI, and am trying to replicate some reports I typically create in EXCEL Pivot Tables, but can't seem to get around two small issues.

My data consists of multiple rows of distinct data per day, which I summarize using SUM for that Day.

I then need to calculate 95th Percentile of those values for that Month.

The table graphic perfectly summarizes the per day values, but I can't get the Percentiles, which are Measures, to work (displayed as multiple value card circled in Red).

Additionally, my timestamp data to filter the page just reverts to Year only (circled in Green).

Any help appreciated while I wade throught the documentation...

Jonathan

[v-caliao-msft]

Hi @jonathanb,

Based on  your description, what's your expected result?

For your timestamp year slicer, which formula are you using? Please provide us more information, so that we can make further analysis.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visualization-types-for-reports-an...

Regards,

Charlie Liao

[jonathanb]

Hi I am new to Power BI, and am trying to replicate some reports I typically create in EXCEL Pivot Tables, but can't seem to get around two small issues.

My data consists of multiple rows of distinct data per day, which I summarize using SUM for that Day.

I then need to calculate 95th Percentile of those values for that Month.

The table graphic perfectly summarizes the per day values, but I can't get the Percentiles, which are Measures, to work (displayed as multiple value card circled in Red).

Ad

[jonathanb]

Hi I am new to Power BI, and am trying to replicate some reports I typically create in EXCEL Pivot Tables, but can't seem to get around two small issues.

My data consists of multiple rows of distinct data per day, which I sumarise using SUM for that Day.

I then need to calculate 95th Percentile of those values for that Month.

The table graphic perfectly summaires the per day values, but I can't get the Percentiles, which are Measures, to work (displayed as multi value card circled in Red).

[jonathanb]

Hi I am new to Power BI, and am trying to replicate some reports I typically create in EXCEL Pivot Tables, but can't seem to get around two small issues.

My data consists of multiple rows of distinct data per day, which I sumarise using SUM for that Day.

I then need to calculate 95th Percentile of those values for that Month.

The table graphic perfectly summaires the per day values, but I can't get the Percentiles, which are Measures, to work (displayed as multi value card circled in Red).