Show Data Point as a Table not showing

[Danny-1942]

I have created a Power bi with all the excel data sat behind feeding into it to create the visuals, etc. Most of my visuals I am able to select 'Show Data Point as a Table' and the line detail apears no problems. However, I there are some visuals that do not show this option. These are not formatted differently in any way and the data behind this is the same source as other visuals which have this option. 

can anyone help?

[Anonymous · Accepted solution]

Hi @Danny-1942 ,
According to the documentation I checked, there are indeed some limitations to this feature, as mentioned in the official docs:
Are only available for specific types of data. In the Power BI service, if you hover over a data point and don't see the option to Show data point as a table, then the visual contains data that doesn't support it. In Power BI Desktop, if the menu option for Data point table is grayed out, then the visual contains data that doesn't support it. 
For example, if the visual has a measure in the Value field, showing the data underlying a data point will not be available.
So you need to make sure that the data model behind these visual objects doesn't contain any metric values or calculations that might prevent functionality from being available. Complex metric values or specific DAX functions may limit the ability to view data in tabular form directly from the visual object.

For a more detailed description of this feature you can refer to this document
Show the data that was used to create the report visual - Power BI | Microsoft Learn

Best regards,

Albert He

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

[Danny-1942]

Hi Albert, thank you very much for your post, this has helped me to no end. very clear and i understand the issue. The visuals i had contained calculations, i have managed to change this and get the same outcome on the visual. The Show data point as a table is now available. Thanks again.