Forum Discussion
Custom Usage Report in PBI Desktop
Super UserOnce you have this table, you can create a measure that calculates the number of report views for each Section ID. You can do this by using the COUNT or SUM aggregation function on a field that contains the number of views for each report.
- Sahir_Maharaj
Next, you can create a matrix visual in Power BI that uses the Report Name as the row label, the Section Name as the column label, and the measure that you created as the value. This will give you a matrix that displays the number of report views for each Section ID in the report.
- Sahir_Maharaj
You can also add a drill-through hierarchy to your matrix visual to allow you to navigate the report structure and view the details of each report view by Section ID. To do this, you can create a hierarchy using the Report Name and Section Name fields and then enable the drill-through option in the matrix visual.
- Sahir_Maharaj
If you are still having trouble creating this matrix, please do let me know as I will do my best to assist.