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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
harry6810
Frequent Visitor

Creating chart from the table

Hi guys, 

how to create a chart from the table when all values (except the first one GFK SO) are based on measures? I need to know how many of our products have the lowest price, how many A, B competitors etc.

harry6810_1-1636121775574.png

Thank you for any help.

J. 

 

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @harry6810 ,

According to your description, I create a sample, “Group” is a column of a new table, and “Count ” is a measure.

vkalyjmsft_0-1636357840217.png

 

Best Regards,
Community Support Team _ kalyj

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

View solution in original post

4 REPLIES 4
v-yanjiang-msft
Community Support
Community Support

Hi @harry6810 ,

According to your description, I create a sample, “Group” is a column of a new table, and “Count ” is a measure.

vkalyjmsft_0-1636357840217.png

 

Best Regards,
Community Support Team _ kalyj

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

Thank you very much @VahidDM , I will try this shortly. In the meantime I have a next question, maybe you will able to help. I will try to briefly describe what I would like to achieve. So, I have 4 main datasets:
- Sales report [WESI]
- Product base [d_product]
- GFK data [GFK]
- Price monitoring [prices]
Each of those tables has common fields - processor, RAM, graphic card etc. Then I created relations in order to link all 4 main datasets, each parameter separately (GPU, CPU, RAM). Additionally, I created relations with next two parameters "series" and "vendor" in a separate table and I added a column with our serie which is the equivalent to a competing one.
And now, I created a hitlist based on the GFK report using all the matched parameters. Based on the "series" table and "match" column, I added a column with our series to the created table. Now the question is how to insert a calculated measure with minimum price [min. price] that will apply to our "match" product and not to the to the oryginal, competitor series? Filtering by manufacturer, of course, returns an empty value. This should work as follows:
- find a product series from the series table [series]'series1' and assign an equivalent from the match column [series]'match' and then get the minimum price [prices][min. price]* for a specific config back from our series from [series]'series1'.

[min. price] is a measure:
[min. price] = CALCULATE(MIN('prices'[lowest_price]),LASTDATE('prices'[data]))

 

harry6810_0-1636492966656.png

 

 

 

 

VahidDM
Super User
Super User

Hi @harry6810 

 

Can you share a result you are looking for? (create a sample chart with the same name in excel and send it here)
Is it possible to share your PBIX file [after removing sensitive data?

Appreciate your Kudos!!

 

Hi @VahidDM 

I need to have sth like this for a start (more or less):

harry6810_0-1636204431185.png

 

In the meantime, I added a column grouping discrepancies between our company and competitors and discrepancy ranges <100, <200, etc.
Unfortunately, I am now able to send you files because there are too many relations (each feature like CPU, GPU is a separate dataset) and the files themselves are in the cloud :(. 

 

Thank you very very much for any ideas and tips! 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.