Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Cardi0z
Helper I
Helper I

need help: how to calculate measure then display it into the table and bar chart power bi

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 

3 REPLIES 3
Cardi0z
Helper I
Helper I

Dear @amitchandak 

1. below is the data source

Cardi0z_0-1718093608078.png

 

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)

Cardi0z_1-1718094023340.png


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.

Cardi0z_2-1718094235736.png


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.

Cardi0z_3-1718094349203.png


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.

amitchandak
Super User
Super User

@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.

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

@amitchandak 

halo, can you help me?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.