Forum Discussion

Marvinnv's avatar
Marvinnv
New Member
4 years ago
Solved

Reproducing pivotchart in Power BI

Hello,

I would like to reproduce the Pivotchart below in PowerBI:

Relevant pivottable:

Does anyone know how to achieve the above in PowerBI?

I've used Charticulator and the Multiple Axis Charts but I can't reproduce the above.

 

Need Help

7 Replies

    • Marvinnv's avatar
      Marvinnv
      New Member
      4 years ago

      Hi mh2587 ,

       

      When I try this I get the two views below (after drilling down).

       

       

      However, I would like the data to be summarized as per below:

       

       

      So basically displaying two categories at once instead of displaying one category at the time.

       



      • mh2587's avatar
        mh2587
        Super User
        4 years ago

        Yup you have to drill down for further categories But you have achieve this by using slicer and just put the measure in the value

    • Marvinnv's avatar
      Marvinnv
      New Member
      4 years ago

      Hi negi007 ,

      I would need something similar to yours but when with one extra category like in my Excel example.

      So basically I would like PowerBI to display two categories at the same time instead of only one.

       

      • negi007's avatar
        negi007
        Community Champion
        4 years ago

        Marvinnv 

        you can have as many categories you wish to have like below