Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 them in a clustered column chart.
Desired Visual:
Actual Visual:
Please help me with this.
@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
I can not use this third-party extension you implemented, is there any other way you can suggest?
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.
User | Count |
---|---|
59 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
78 | |
62 | |
45 | |
40 | |
39 |