Forum Discussion
POWER BI
Can anyone help me and please tell thta how can i make all the repeated name once only so that I can be able to see the name once and its associated data n=may not chabge its differenet and if its same then can be chnaged .
- Anonymous4 years ago
Hi Anonymous ,
According to research, if the Value is centered, it will be affected by the header. When you apply the color to the header, when you open "Apply to values", the color will also be directly applied to the Value corresponding to the header.
You can perform some operations on Value alone here, without being affected by the header, but there is no centering option here, only font, bold, italic and other functions are supported.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
10 Replies
- AnonymousNot applicable
Can anybody also tell me how to make custom headers colored without using any conditiion
- amitchandakSuper User
Anonymous , Under column header(Matrix visual) you have the color option for background and font, Please check if that can help
- AnonymousNot applicable
amitchandak it doent work in table?
- amitchandakSuper User
Anonymous , You can use Matrix visual with Stepped layout off and check
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
- AnonymousNot applicable
amitchandak for the grouping thing or for colored header and have you used it?
- AnonymousNot applicable
amitchandak matrix visual will not work in my case it contains lot of data so its need to be done in table itself
- AnonymousNot applicable
Hi Anonymous ,
You can use the Specific column of the matrix to give each header a custom color.
Here are the steps you can follow:
Visualizations - Format - Visual - Specific column. Select the color column you want to add to customize the color
Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- AnonymousNot applicable
Thanks alot it helped me very much now I want that values didnt got colored but it should aligned in center how to do that without chaging header.
- AnonymousNot applicable
Hi Anonymous ,
According to research, if the Value is centered, it will be affected by the header. When you apply the color to the header, when you open "Apply to values", the color will also be directly applied to the Value corresponding to the header.
You can perform some operations on Value alone here, without being affected by the header, but there is no centering option here, only font, bold, italic and other functions are supported.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- AnonymousNot applicable
Anonymous Can you please see above pic and tell me how to do grouping in this so that on one click I will be able to see all the related data?