Filtering on measure columns

[JeroenSchubert]

Hello,

I just started working with power bi and currently I am trying to create an analysis report on the data of the world governance indicators from the world bank. The data contains per country and year the respective percentile rank for an indicator (i.e. control of corruption). I want to compare the percentiles from certain countries with eachother and to that matter opt for a radar chart.

I first had the data as shown below, but altered it by pivoting the country colum:

standard table

pivoted table

The reason for the pivoting is that otherwise the sum of all filtered countries would show per indicator. 

This resulted in the below basic report:

Report WGI Indicators

So far so good. The data on governance indicators however, has hundreds of countries and I want the report user to filter a number of countries and based on this selection the radar chart should be populated by this filtered selection. Can this actually be done and if so how should I approach this?

Regards,

Jeroen

[v-piga-msft]

Hi @JeroenSchubert,

By my tests, there is no good idea to create a country slicer based on the pivoted table. This may be a limit for Radar chart.

You may need to try another chart such as clustered column chart.

Best  Regards,

Cherry

[JeroenSchubert]

Hi @v-piga-msft,

Thank you for looking into this. You might be indeed right. There is one more thing I want to try out as I have found now another post that might solve it still:

Possible solution

I need to investigate this further naturally. 

I also notice a missing element within radar chart, but others have mentioned that before as well and that is the fact that the Y-axis cannot be fixed to values.  Say theoretically I find a country with all indicators at 100 and show it seperately and then select another country with all indicators at 50 the report reader would see them both at the max of the radar chart,

As mentioned before thanks for having a go at it.

Regards,

Jeroen