How to sse data segmentation to filter one column in a chart

[Jefeliude]

Hi Experts, I need a help.

I need made a chart with two columns ('New leads', 'Total Sales') and a line 'Conversion rate' in a certain period, which will be selected by the users. I have a date for each one of columns, for example "lead created in" and "sales date", I need to show for the users the number of each one and the conversion rate in a chart like this

Here is my problem, I need to show all the sales of the selected period, independent if they're part of the new leads or the past backlog. I want when the users select the filter "Lead created in" only the lighter column be filtered and when they use the filter "Sales Date" only the darker column be affected.

is that possible? I appreciate any help.

Thanks!

[simrantuli · Accepted solution]

Hi @Jefeliude,

You will have to make the below modifications in your measures.

Measure for Light blue bar: Use ALL([Sales Date]) as a filter expression in the measure

Measure for Dark blue bar: Use ALL([Lead Created In]) as a filter expression in the measure

For more information, go through the below link:

https://docs.microsoft.com/en-us/dax/all-function-dax

Best Regards

Simran Tuli

[Jefeliude]

Thanks @simrantuli it worked!

[amitchandak]

@Jefeliude , typically we create date table join both dates with that and userelation to activate this join.

In this case we need to use the dates or two date tables.

For a single date table - https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in...

Calculations will depend on which date you want to use for the ratio

[Greg_Deckler]

@Jefeliude - Probably doable, if you are careful about using ALL/ALLEXCEPT in your measures, but not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.