Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tolgaa
Frequent Visitor

How can I create emty rows in a table whenever there is a date change

I have a huge table report in PowerBI and would like insert empty rows just before date change so that it will be more readeble to end users (data will be grouped based on dates). 

 

I will appreciate if somebody can guide me how to achieve this.

1 ACCEPTED SOLUTION
Thejeswar
Resident Rockstar
Resident Rockstar

I don't think there is any direct way you can do this in a table visual. This is more like an excel kind of interface you are looking for. But Power BI Desktop is designed for Sophisticated Data Visualization purposes rather than Tables and Matrix

 

You could instead try using a Report Builder that can give you pixel perfect reports. Not sure if that has the allowance to add empty rows. But since it is very similar to the Old SSRS I guess it could help you with this. You can explore on this

 

Regards,

View solution in original post

1 REPLY 1
Thejeswar
Resident Rockstar
Resident Rockstar

I don't think there is any direct way you can do this in a table visual. This is more like an excel kind of interface you are looking for. But Power BI Desktop is designed for Sophisticated Data Visualization purposes rather than Tables and Matrix

 

You could instead try using a Report Builder that can give you pixel perfect reports. Not sure if that has the allowance to add empty rows. But since it is very similar to the Old SSRS I guess it could help you with this. You can explore on this

 

Regards,

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.