Forum Discussion

NPC's avatar
NPC
Helper I
2 years ago
Solved

Dynamic Column Possible?

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.