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?

Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    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.

4 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Should be easier way, like tooltip or such. That complexity means that product is not very mature.

      Can we submit a feature request, what do you think?

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

        It would be nice if there were an easier way.

        You can submit your idea to Power BI Ideas .


        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.