Dynamic column header in table based on values in one field

Question

I have a text field in a table that I’m displaying the count for. The column name is Details, and the data in this column is either Stationary or Mobile. I have a slicer for the same field to show the count of the two results (stationary vs mobile).

Stationary
Mobile
Stationary
Stationary
Mobile

Count: 3 when stationary is selected in slicer
Count: 2 when mobile is selected in slicer

How do I dynamically change the column header in my table instead of Details to be Count of Stationary or Count of Mobile?

Is there a way to do this without creating separate measures to count each stationary and mobile values?

ritaf1983 · Answer

Hi&nbsp;Soc3&nbsp;You can use matrix instead of table and this is how it works as a default :

The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

ray_minds · Answer

Hi&nbsp;Soc3&nbsp;Yes, you can dynamically change the column header in Power BI without creating separate measures for counting Stationary and Mobile. You can achieve this using a Measure and a Field Parameter.&nbsp;Steps:&nbsp;Create a Measure for Dynamic Column Header:&nbsp;&nbsp;&nbsp;This measure will return "Count of Stationary" when "Stationary" is selected in the slicer and "Count of Mobile" when "Mobile" is selected.&nbsp;2. Create a Measure for Count:&nbsp;&nbsp;&nbsp;&nbsp;3.&nbsp; Add the Measures to Your Table Visual:&nbsp;Use DynamicColumnHeader as the column header.&nbsp;Use CountSelected as the column values.&nbsp;&nbsp;Since DynamicColumnHeader changes based on the slicer selection, the table will update dynamically.&nbsp;&nbsp;When Mobile is selected:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;When Stationary is selected:&nbsp;&nbsp;&nbsp;Best regards,Ray Mindshttp://www.rayminds.comhttps://www.linkedin.com/company/rayminds/If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

soc3 · Answer

Hi&nbsp;Ritaf1983&nbsp;,&nbsp;Thanks for your reply.&nbsp;&nbsp;I have multiple values to include in the matrix and when I add those values, the column header gets bumped up a level.&nbsp;&nbsp;&nbsp;I've changed the terms, Detail=Advanced Booking Status and Stationary/Mobile are Advanced Purchase and Not in Advance. How do I associate the dynamic column header with the Count value?

soc3 · Answer

Hi&nbsp;Ray_Minds&nbsp;,&nbsp;Thanks for your reply. I was hoping to accomplish this in a table instead of a matrix. Do you know how to implement in a table specifically where I can't differentiate between a column and a value?

ritaf1983 · Answer

Hi againPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...Please show the expected outcome based on the sample data you provided.https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523