To do this, you can create a separate page in your report that displays the raw data in a table, and then configure the visual on your main page to have a drillthrough action that links to this raw data page. One possible solution is to use the "Drillthrough" feature in Power BI, which allows users to see the raw data that underlies a visual by clicking on it. It sounds like the issue is that the common table at the bottom of the report page is not filtering the data based on the same conditions that are used to calculate the metrics displayed in the visuals. Please help solve this issue or help us find an alternative method. The table does not respect the date filter that is applied and any condition which is applied in the metric. For example, if we click on a bar showing "Ending Headcount" for "Males", the data table filters all the males correctly but the number of employees in the table does not match the ending headcount number. Now, we added a common table at the bottom of the report page to export the employee level data, however, when we try to filter the table by clicking on any bar/column in the visuals, we noticed that the row count in the data table does not match the selected metric. These metrics are used across different visuals on the page. We use conditions with different dates (like date of joining and date of exit) to calculate important metrics like Starting Headcount of the company, Ending Headcount of the company, Added Employees, Exited Employees, etc. The date table does not have any relation with the attribute table. We are using an independent date filter on the report to filter the measures. Below is the way we are trying to achieve this but its not working.
Our objective is to give an option for user to see raw data when they click on any visuals.
0 kommentar(er)
