Forum Discussion
Create sections in report using Power BI Desktop optimized for Power BI Report Server on premise
You can have visual level filters for each of "Table" visual. Then you can see output as below:
Hi v-piga-msft,
Sorry for the confusion. I have created a report by getting data from SSAS. That is not the problem. My problem is in my report, I do not know how to break or section my data. I'm using the Table Visualizations so my report looks like this currently:
Service Name | LastName | FirstName
Active Doe John
Inactive Hook James
Active Kent Clark
Inactive Pan Peter
I want the report to look like this:
Active
LastName | FirstName
Doe John
Kent Clark
Inactive
LastName | FirstName
Hook James
Pan Peter
So basically, the report is sectioned by Service Name which is Active or Inactive and the corresponding values (LastName, FirstName) for that Service Name is listed below the Service Name.
You can have visual level filters for each of "Table" visual. Then you can see output as below:
I am fairly new to Power BI Desktop. While using Visual level filters, I do not get the desired output. If I select Service Name under Filters and select Active and Inactive, it does not break the data into sections. Would you be able to show me an example of how to use the Visual level filters?
He's probably suggesting creating two sections, one for Active and one for Inactive...
