Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to create Graph 1 but my table structure is as Table 2, any measure to achieve this.
Also when table 2 is unpivoted (Table 3) then only its showing total otherwise Total is not appearing in Table 2.
Please help me resolve it, Thanking you in advance
Solved! Go to Solution.
Hi @Harsh333,
I'm not sure if I got your point accurately. You can create a separate measure for each category.
Measure A = CALCULATE(SUM(Test[A]),ALLEXCEPT(Test,Test[Month]))
Measure B= CALCULATE(SUM(Test[B]),ALLEXCEPT(Test,Test[Month]))
Measure C= CALCULATE(SUM(Test[C]),ALLEXCEPT(Test,Test[Month]))
Measure D= CALCULATE(SUM(Test[D]),ALLEXCEPT(Test,Test[Month]))
Measure E= CALCULATE(SUM(Test[E]),ALLEXCEPT(Test,Test[Month]))
Measure FYFC = CALCULATE(SUM(Test[FYFC]),ALLEXCEPT(Test,Test[Month]))
Then put your measure in the chart, you will get a result like this:
There is another, more convenient solution but it does not use measure.
Based on what you mentioned above, you can unpivot Table2. You can enter data after unpivot into Power BI Desktop as Table 3.
Then use Table 3 to create a matrix like this:
Then adjust the matrix chart to a column chart. Put category in Axis. You can see this:
A demo is attached for your reference.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Harsh333,
I'm not sure if I got your point accurately. You can create a separate measure for each category.
Measure A = CALCULATE(SUM(Test[A]),ALLEXCEPT(Test,Test[Month]))
Measure B= CALCULATE(SUM(Test[B]),ALLEXCEPT(Test,Test[Month]))
Measure C= CALCULATE(SUM(Test[C]),ALLEXCEPT(Test,Test[Month]))
Measure D= CALCULATE(SUM(Test[D]),ALLEXCEPT(Test,Test[Month]))
Measure E= CALCULATE(SUM(Test[E]),ALLEXCEPT(Test,Test[Month]))
Measure FYFC = CALCULATE(SUM(Test[FYFC]),ALLEXCEPT(Test,Test[Month]))
Then put your measure in the chart, you will get a result like this:
There is another, more convenient solution but it does not use measure.
Based on what you mentioned above, you can unpivot Table2. You can enter data after unpivot into Power BI Desktop as Table 3.
Then use Table 3 to create a matrix like this:
Then adjust the matrix chart to a column chart. Put category in Axis. You can see this:
A demo is attached for your reference.
Hope it helps.
Best Regards,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , refer if this custom visual can help
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200000675?tab=overview
Sorry but I think you misunderstood my problem:
I want to created above bar graph (1) if my table was structured as (2).
not bar graph with table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |