Forum Discussion

JeroenSchubert's avatar
JeroenSchubert
New Member
7 years ago

Filtering on measure columns

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 countr...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

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's avatar
    JeroenSchubert
    New Member
    7 years ago

    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