Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to find relation between visualization and a field?

If you rename a field in Visualizations sidebar it is not even to what field (in Fields sidebar) it refer to. Is there some easy way to find out an exact mapping?
  • v-lionel-msft's avatar
    6 years ago

    Hi Anonymous ,

    Maybe  the "Performance Analyzer" can help you.

    If I change the name of [Brand] column into "Changed name":

    Then, I can find the fields when check the query.

    // DAX Query
    EVALUATE
      TOPN(
        502,
        SUMMARIZECOLUMNS(
          ROLLUPADDISSUBTOTAL(ROLLUPGROUP('Sales'[Brand], 'Sales'[CountryRegion]), "IsGrandTotalRowTotal"),
          "SumBudget", CALCULATE(SUM('Sales'[Budget]))
        ),
        [IsGrandTotalRowTotal],
        0,
        'Sales'[Brand],
        1,
        'Sales'[CountryRegion],
        1
      )
    
    ORDER BY
      [IsGrandTotalRowTotal] DESC, 'Sales'[Brand], 'Sales'[CountryRegion]

     

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.