Forum Discussion

FrankWe's avatar
FrankWe
Helper II
1 year ago
Solved

Problem with data for Scatter chart

Hello all,   I trying to create a scatter chart in Power BI now and have big problems to get the necessary data for the chart that I would like to create. I tried a lot of different ways that I fou...
Need Help
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    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.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi FrankWe ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you burakkaragoz for the prompt response.

Ranking and tiering are done in memory using measures, not requiring a date field.

You don’t need Power Query or calculated columns – this is fully DAX-driven and responsive to slicers.

I have done some changes in the attached pbix file to replicate the scenario by creating two measures (FWE GM % Rank,Cumulative GM % and a column named Assigned Tier) as per my understanding, I hope it helps.

 

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.

 

FrankWe's avatar
FrankWe
Helper II
1 year ago

Hi v-venuppu,

 

i just downloaded your pibx file and tried it. The problem I have still exists. Please try and remove as a test the filter text in the text slicer "Item" and see what happens. In my case I get the error that there are not enough resources available. That is the problem I have