Help the doctor (me)) visualize vitamins and minerals in all food.

[Anonymous]

Hello,

There is freely available data on the official website of the US Department of Agriculture on the content of vitamins and minerals... for all products. https://fdc.nal.usda.gov/download-datasets

I'm trying to download and convert the data "Full Download of All" CSV 449M, but I can't even visualize it, let alone understand where to look for "Turkey Meat" and what is included in 100 grams.
I would like to get a visualization like in the picture.

Help me, how to make such a visualization step by step and save the data in an acceptable format for each member of my family, well, and for all interested participants of this forum.

Respectfully,
Evgeny

[Anonymous]

How to summarize and visualize all the kilocalories, proteins, fats, carbohydrates and other macro- and micronutrients in the products that you ate and drank throughout the day from the reference values ​​of the norm?

For all family members?

Thank you very much Mr. Zhu!

[Anonymous]

Found something similar in a spreadsheet 400 kb https://sourceforge.net/projects/nutritional-tables/

But how to convert it to Power BI?

[v-linhuizh-msft]

Hi @Anonymous ,

Minerals as an example, first of all in Excel on the data to carry out simple processing, delete unnecessary rows:

After getting the data from EXCEL, click Transform data in Power BI to enter Power Query Editor. Select the columns other than minerals and unpivot them:

Do the same for the other table:

Merge two tables together:

Create a measure to get the ratio to the reference value:

Percentage = DIVIDE(MAX('Minerals_Merge'[Value]),MAX('Minerals_Merge'[Minerals.Value]))

Create the visual as shown:

You can also create slicers to filter for different things, minerals, people, etc.
Result:

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Anonymous]

Thank you very much dear Mr. Zhu!

Allow me not to mark your comment as a solution yet?
I want to understand how to sort all the data correctly.
Start learning M language in Power Query?

Thanks again, you spent your time!

[v-linhuizh-msft]

Hi @Anonymous ,

According to the link you provided, I imported the three tables: food ,food_nutrient and nutrient, and due to the large amount of data, I'm only using some of them:

Create relationships for the three tables:

Then create a measure:

Rate = DIVIDE(SUM('food_nutrient'[amount]),CALCULATE(SUM('food_nutrient'[amount]),ALLSELECTED('food_nutrient'),'nutrient'[unit_name]=MAX('nutrient'[unit_name])))

Result:

You can modify it to suit your specific needs, the links related to data modeling are as follows:

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

Data reduction techniques for Import modeling - Power BI | Microsoft Learn

Best Regards,
Zhu

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.