Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiple Column in a clustered column Chart

Hello, I'm new to Power BI so there are a lot of things I can not figure out. I need little help with a problem, I have a few custom columns having a count of records in them and I want to put the...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You need to create measures for all of them and put in bat visual without a axis or create a calculation group on those measures and use that group on the axis

 

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I can not use this third-party extension you implemented, is there any other way you can suggest?

  • RicoZhou2's avatar
    RicoZhou2
    Resolver I
    4 years ago

    Hi Anonymous ,

     

    If your data model looks like as below, I suggest you to create a new table with all column names and add it into visual X-Axis Field.

    Axis = 
{"Phase 1","Phase 2","Phase 3"}

    Measure:

    Measure = 
SWITCH(SELECTEDVALUE('Axis'[Value]),"Phase 1",SUM('Table'[Phase 1]),"Phase 2",SUM('Table'[Phase 2]),"Phase 3",SUM('Table'[Phase 3]))

    Result is as below.

     

    Best Regards.