Forum Discussion

copzyz123's avatar
copzyz123
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

Problem with creating clustered column chart with percentile calculation

Hello Power BI gurus,

 

I have a small problem with creating a new table just for percentile purpose, hoping you could help me out here. Right now I have a table with several columns there and I need to do a percentile analyze just for one column. Also, I have set up several filters in the report so I can see how data changes when filters applied.

 

Since there is no good percentile visual to use, I did these:

1. Creating a new table, specifying percentages I want for calculating percentile, with this DAX: 

PercentileTable = {0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9}.

2. Creating a new column to percentile calculation, with DAX:

Column = PERCENTILE.EXC(SourceData[DurationInMs], PercentileTable[value])

3. Creating a clustered column chart for this new table.

 

 

Issue I am facing:

When applying data slicer filter on the page, the chart table is not refreshing at all. I have done some research but I need some sample on the "Filter context". Hope some one can help me out here.

 

Thank you very much!

Need Help
Tips and Tricks

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    5 years ago

    Hi copzyz123 ,

     

    If you are creating a calculated column for the percentile the values that you have for that column will not be impacted by the  percentile of the other table when you try to have it dynamic you need to create a calculated measure instead of a column.

     

    Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

    If the information is sensitive please share it trough private message.