Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating a chart with user defined axis

Hi Can anyone help with this query? I need to produce a scatter which relies on the user defining x and y axis (using slicers) - is there any way to do this without creating a summarised table of ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    With current table format, it might not possible to create such a scatter chart. You may need to generate a new calculated table with a new structure.

    Test3 =
FILTER (
    CROSSJOIN (
        FILTER ( Test2, Test2[Name] = "Actual" ),
        SELECTCOLUMNS (
            FILTER ( Test2, Test2[Name] = "Expected" ),
            "Name2", Test2[Name],
            "Phase2", Test2[Phase],
            "Score2", Test2[Score]
        )
    ),
    Test2[Phase] = [Phase2]
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

I get below result if directly placing [category] onto X-axis and Y-axis, and plotting [Score] into Details.

 

Is that what you want? If not, would you please show us your desired output? If you want to show total score per Category in scatter chart, I think you should create a summarised table.

 

Regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Yuliana


Thank you for your reply, but I wasn't very clear and this isn't what I was looking for.  I have the data table below and the scatter chart I'd need.  Does this help?  I'm thinking I may have to use parameters, but I'm not sure how to do this.

 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

     

    With current table format, it might not possible to create such a scatter chart. You may need to generate a new calculated table with a new structure.

    Test3 =
FILTER (
    CROSSJOIN (
        FILTER ( Test2, Test2[Name] = "Actual" ),
        SELECTCOLUMNS (
            FILTER ( Test2, Test2[Name] = "Expected" ),
            "Name2", Test2[Name],
            "Phase2", Test2[Phase],
            "Score2", Test2[Score]
        )
    ),
    Test2[Phase] = [Phase2]
)

     

    Best regards,

    Yuliana Gu