Forum Discussion

Poongovil's avatar
Poongovil
Frequent Visitor
6 years ago
Solved

100% Staked Column Chart is not working

New to power BI; Still learning ... So please excuse.   I have created the below pivot table. Want to create a 100% Stacked Column chart as shown below in the table with 4 stacked bars.  Exc...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Poongovil ,

     

    I created a measure and used level as a legend.

     

    Measure =
VAR COUNT_BY_LEVEL =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        ALLEXCEPT ( 'Table', 'Table'[ID type], 'Table'[level] )
    )
VAR COUNT_BY_TYPE =
    CALCULATE ( COUNT ( 'Table'[ID] ), ALLEXCEPT ( 'Table', 'Table'[ID type] ) )
RETURN
    DIVIDE ( COUNT_BY_LEVEL, COUNT_BY_TYPE )

     

    Sample .pbix

    If the problem persists,could you share the sample pbix  or sample data?(Please mask any sensitive data before uploading.)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Poongovil's avatar
    Poongovil
    Frequent Visitor
    6 years ago

    Sorry it does not work.... Tried swapping the legend and axis column

    • V-lianl-msft's avatar
      V-lianl-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Poongovil ,

       

      I created a measure and used level as a legend.

       

      Measure =
VAR COUNT_BY_LEVEL =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        ALLEXCEPT ( 'Table', 'Table'[ID type], 'Table'[level] )
    )
VAR COUNT_BY_TYPE =
    CALCULATE ( COUNT ( 'Table'[ID] ), ALLEXCEPT ( 'Table', 'Table'[ID type] ) )
RETURN
    DIVIDE ( COUNT_BY_LEVEL, COUNT_BY_TYPE )

       

      Sample .pbix

      If the problem persists,could you share the sample pbix  or sample data?(Please mask any sensitive data before uploading.)

       

      Best Regards,
      Liang
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • Poongovil's avatar
        Poongovil
        Frequent Visitor
        6 years ago

        Thank you. That works!!!