Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Display the number of total records on the footer respective reports in power BI
Example:
This is a SSRS paginated report screenshot, in power BI report can we create similer to this?(Highilted in yellow) Someone please suggest?
Solved! Go to Solution.
Hi @charanoffbit ,
Do you want to get the number of total records just as shown in the paginated report? If yes, you can get it by the following steps:
1. Create a measure as below to get the number of total records: As checked your screenshots, it seems that there is one filter in the visual.
Measure =
CALCULATE (
COUNT ( 'Table'[Alternate Id] ),
FILTER ( 'Table', 'Table'[Locationxxx] = "xxx" )
)
2. Create a card visual and put the above measure on it. Drag the card visual under your table visual
If the data of your screenshot from multiple tables, please provide some sample data(exclude sensitive data) in these table with Text format and your expected result with backend logic base on the provided sample data. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
Best Regards
Hi @charanoffbit ,
Do you want to get the number of total records just as shown in the paginated report? If yes, you can get it by the following steps:
1. Create a measure as below to get the number of total records: As checked your screenshots, it seems that there is one filter in the visual.
Measure =
CALCULATE (
COUNT ( 'Table'[Alternate Id] ),
FILTER ( 'Table', 'Table'[Locationxxx] = "xxx" )
)
2. Create a card visual and put the above measure on it. Drag the card visual under your table visual
If the data of your screenshot from multiple tables, please provide some sample data(exclude sensitive data) in these table with Text format and your expected result with backend logic base on the provided sample data. It would be helpful to find out the solution. You can refer the following link to share the required info:
How to provide sample data in the Power BI Forum
Best Regards
Thank you
I dont think there is currently any visuals that allow paginating the data (with much annoyance to me aswell as i think this would be an excellent visuall) obviously you can calculate the number of records in your table to drop as card visual or similar if that is all you are interested in.
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |