Forum Discussion

Noob78's avatar
Noob78
Frequent Visitor
9 years ago
Solved

Advanced histogram parametring by cluster of data

Hi people! I have once again an issue, concerning histogram parametring. Below are the samples: - my data is as seen in the table : division by country/region/zone/dealer - my histogram should sh...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Noob78，

    Click your field(for example:%Country) in Fields Panel, then under Modeling ribbon,click the percentage format, you will get your desired result.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Noob78,

Based on your description and screenshots, it seems that you want to create a column chart using sample data in Power BI Desktop and want to filter it with different levels of slicers, right?

If that is the case, you can create a Clustered column chart using fields as shown in the following screenshot, then create 4 slicers using country/region/zone/dealer field. You will be able to filter the chart using slicers at different levels.

 

For more details, you can review this attached PBIX file.

Thanks,
Lydia Zhang

  • Noob78's avatar
    Noob78
    Frequent Visitor
    9 years ago

    Thank you! This is quite it visually.

    How have you determined the %? A measure?  Directly in data?...

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Noob78，

      Click your field(for example:%Country) in Fields Panel, then under Modeling ribbon,click the percentage format, you will get your desired result.



      Thanks,
      Lydia Zhang

      • Noob78's avatar
        Noob78
        Frequent Visitor
        9 years ago

        Thank you Lydia