Dynamic Column Possible?

[NPC]

Hi All,

I have this chart below and would like to use the date filters to get the number of customers impacted by outages only in 2022, for example:

  I'm using the code below to create a column - Y axis data (renamed in the charts as # Outages):

The Y axis is grouping all the customers together who have been impacted by outages 5 times for example and the X axis gives me a total count of the customers. Because the Y axis data comes from a column, it is fixed and does not adjust when filtering with a date column.

Is there a way I can change this so that the # Outages column is dynamic and correctly responds to date filtering?

Your help would be appreciated. 

[Anonymous · Accepted solution]

Hi @NPC 

There is a way that, you create years count column e.g the count in 2022, the count in 2023, then set them as field paramater, when you select the 2023 year in a slicer, then select the related paramater. 

e. g 

You can refer to the following link and the attachments

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @NPC 

Please 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