Custom Usage Report in PBI Desktop

[109264]

Can anyone tell me how to get a matrix that contans the number of the Report Views by Section ID. I'm trying to create a hirarchy of the Report Name and Section Name in a report, but there seems to be no relationship between the section id and a number of views for that section in the report

Thanks!

[Sahir_Maharaj]

Once 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]

If you are still having trouble creating this matrix, please do let me know as I will do my best to assist.

[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]

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]

Hello @109264,

To create a matrix that contains the number of report views by Section ID in Power BI, you can start by creating a table that contains the Report Name, Section Name, and Section ID. This table should be created using a query that pulls data from the source system where the report data is stored.