Forum Discussion

harry6810's avatar
harry6810
Frequent Visitor
4 years ago
Solved

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 compe...
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi harry6810 ,

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

     

    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.

VahidDM's avatar
VahidDM
Super User
4 years ago

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!!

 

harry6810's avatar
harry6810
Frequent Visitor
4 years ago

Hi VahidDM 

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

 

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!