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

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