Forum Discussion

h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

Stack Column Chart to count the no of projects

Hi All,   I received an enhancement request for the solution (Solved: Re: Stacked Column Chart to show Count of Projects - Microsoft Fabric Community). Please assist me with the following:   We h...
Need Help
h11's avatar
h11
Icon for Helper III rankHelper III
2 years ago

Hi Sam,

 

I tried but no luck. I used the same formula. Also applied the format, edit interaction filter on the chart and see no difference.

 

 

    • h11's avatar
      h11
      Icon for Helper III rankHelper III
      2 years ago

      Thank you for sharing the PBI file. I double checked and followed the same procedure.

       

      I'm encountering an issue where the count of projects is only displayed for a few vendors, and moreover, all three bars are showing the same count.

       

       

       

      Clicking on each bar of the 2nd chart to view project details in the table below does not display the corresponding projects. Instead, it reverts to the original graph. To cross verify, I added a table in your power BI to see if it is working fine. Your file also didn't show the correct project details when I clicked on each bar of 2nd chart. 

       

       

       

      • SamWiseOwl's avatar
        SamWiseOwl
        Icon for Super User rankSuper User
        2 years ago

        Hi h11 

        The structure of your file must be different to mine.

        Please modify the sample file I sent you to reflect the structure of your and return it.