Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have developed a report based matrix report.
all columns appear immediately one next to another
please provide a pointer to solve the same
thanks
I had the same issue. I created a colum called "S" and replaced the default of Column = with S = and hit the enter key to save the change. Now you have a column of size of 1 character. Repeat creating new columns to be placed between data columns. This give you control of each space. Drop the columns in between the your values in your matrix.
Initially, each new column is set up as a sum column. Leave them that way.
For each new column, drag the column edge indicator <- || -> and drag the column to the desired size thus putting space between your data columns.
Now open the Format tab (paint brush or paint roller) and select conditional formatting. Select each new column ( in this case column S, T and U) and change the column header background color to match the background color of your grid or page color. This will make the column header disappear and make it appear as empty space between your data columns.
I hope this improves the look of your matrix Rajaraman.
Hi @rajaraman,
When the new data is added in to Matrix visual the first time, the column would fit its width automatically which cannot be changed.
You can firstly set "Word wrap" On, and set "Auto-size column width" Off, and then manually change the column width as you need in this scenario.
Regards
i can resize the column width. But i want to increase space between column headers like cellpadding in html
please suggest a workaround or this can be achieved after i publish report to the server?
can some one throw light on this requirement
I have developed a reporting using matrix report
Hi ,
Select your matrix report and go to -->Format -->Alignment -->Choose Center
Manually you can increase widh of the column by draging it try this hope this will work
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |