How to find relation between visualization and a field?

[Anonymous]

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 · Accepted solution]

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]

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]

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.

[Anonymous]

Now tooltip started to appear over Values. It shows relation to Fields.