POWER BI

[Anonymous]

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 .

[v-yangliu-msft · Accepted solution]

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

[Anonymous]

@v-yangliu-msft 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?

[v-yangliu-msft]

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

[Anonymous]

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.

[Anonymous]

@amitchandak matrix visual will not work in my case it contains lot of data so its need to be done in table itself

[amitchandak]

@Anonymous , You can use Matrix visual with Stepped layout off and check

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Anonymous]

@amitchandak for the grouping thing or for colored header and have you used it?

[Anonymous]

Can anybody also tell me how to make custom headers colored without using any conditiion 

[amitchandak]

@Anonymous , Under column header(Matrix visual) you have the color option for background and font, Please check if that can help

[Anonymous]

@amitchandak it doent work in table?