Forum Discussion
Problem with data for Scatter chart
Hi FrankWe ,
Thank you for your Patience..!!
I have created new table under "Table View" tab , please have a look at the attached pbix file.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hi FrankWe ,
Thank you for the Response..!!
Not sure if I understood correctly that I tried removing filter from text slicer "Item", but I was able to see the data.
Please find the screenshot for your reference:
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Hi, at the moment the problem is not in the scatter chart but in the table visual on tab "Table View". The table visual shoudl be sorted by "FWE GM % of Selected" and then I need to have a column with the cumulative sum of "FWE GM % of Selected" in each row. That is the first problem I have. And in the next step then I need to allocate every item in the list to a "Tier". The settings of the "Tiers" are defined in "DIM_Tiers". All items where the cululative sum of "FWE GM % of Selected" is equal or less than 17,5 will be "Tier 1". The next items where the cululative sum of "FWE GM % of Selected" is larger than 17,5 and smaller than 35 will be "Tier 2". The same procedure for "Tier 3" and "Tier 4". You can have a look in the updated Power BI Example file.
