Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Dear All,
below i have attached sample data. need help how to calculate the measure, then display it into the table and bar chart on power bi? this is a little complicated, because the results must be exactly the same. I need logic to calculate it and I still haven't got it.
link:
Sample data
Thank you
CC :
@v-yilong-msft
@v-huijiey-msft
@v-yangliu-msft
@v-rzhou-msft
@v-yetao1-msft
Dear @amitchandak
1. below is the data source
2. I want to visualize a report data table in power BI with values taken from the data source. below is the screnshoot (table 1)
the header name and column "Type" must be the same as the screenshoot above
3. next, i want to create the table data in power bi (table 2), with value from category. below is the screenshoot.
the header name and column "Category" must be the same as the screenshoot above
4. next, i want to create bar chart, with value base on "Tabel 2". below is the screenshoot.
the legend name is "Liquid", "Solid", and "Total". to make it easier to understand, I have included an attachment below:
https://docs.google.com/spreadsheets/d/15T8QHhxz6mF4qRl9y91qLg6ovCwLR1Dy/edit?usp=drivesdk&ouid=1095...
i hope you can help me how to solve the problem.
thank you.
@Cardi0z , what is the measure calculation you need?
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
101 | |
94 | |
69 |
User | Count |
---|---|
173 | |
135 | |
131 | |
96 | |
94 |