Using a slicer to switch the axis of the graph

[danwilson1]

I want to create a graph that shows the number of days between one of the date columns and today's date. I would like to be able to switch the measure using a slicer (e.g. Days since Actioned_Date, Days since Called_Date, Days until Closure_Date) and have the table results update

In addition, I would like to group the days between into groups to make the graph easier to read (e.g. 0-7 days, 14 days, 21 days etc).

The end graph should then show the distinct # ID where 7 days have passed since Actioned_Date etc

My data looks like this:

ID	Actioned_Date	Called_Date	Closure_Date
123567	1/1/2022	5/1/2022	3/3/2022
156842	10/1/2022	12/1/2022	4/4/2022

[danwilson1]

Hi there; thank you for your detailed response! Unfortunately I am not able to get the latest version of a power BI desktop yet. Are you aware of another workaround that doesn't require the Field Parameter function?

[Anonymous]

Hi @danwilson1 ,

Unfortunately, the field parameter may be the only way to do it at the moment. You can check whether the current version of desktop can enable the field parameter function, if not, please refer to this link to get the latest version.

Best Regards,

Neeko Tang

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

[Anonymous · Accepted solution]

Hi @danwilson1 ,

According to your requirements description, you want to achieve the requirements of "Using a slicer to switch the axis of the graph", I have made a related method for your reference based on the sample data you provided, you can first create three measures.

Days since Actioned_Date =DATEDIFF(SELECTEDVALUE('Table'[Actioned_Date]),TODAY(),DAY)

Days since Called_Date =DATEDIFF(SELECTEDVALUE('Table'[Called_Date]),TODAY(),DAY)

Days until Closure_Date =DATEDIFF(SELECTEDVALUE('Table'[Closure_Date]),TODAY(),DAY)

Then create a "Field parameter", which is a preview feature that may require you to update to the latest version of desktop and enable this preview feature, which you can create and set up as such.

Then you can create a visual like this and place this parameter, and the "Field parameter" will automatically produce the slicer of the field for you.

For a detailed description of the functions of "Field parameter", please refer to this document:

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

Regarding what you said later about grouping dates based on a period of time, I doubt the possibility of this feature being implemented in Power BI, you can refer to the "Group and bin" function to check if it can be implemented, which is the official documentation.

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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