How to ignore relationship and create new measure based on new condition?

[YunJ]

Hi,

I have a relationship on Date between these two datasets. I cannot delete it because I have a few charts use "Date" from Date datasets.

However, in this bar chart, I don't want to use this relationship. For example, When slicer Store="LRL FSS", Campaign="618", I would like to show x-axis as 2020.06.01~2020.06.30, when choosing other content from sclicer Store and Campaign, the x-axis data range will change.

But in this case, when I wrote measure like the following, the end date shown on the x-axis is 2020.06.21, which is based on the date to date relationship from my first picture. 

So I'm wondering can it show as 2020.06.30 rather than 2020.06.21.

Another problem is, the date label on the x-axis can not show completely, why only show these three labels?

Please find attached my pbix file.

https://www.dropbox.com/s/2i3y5mttdh0vibz/test.pbix?dl=0

Not sure whether I'm expressing understood. Please let me know if there is any confusing. Thanks a lot for your time!

[v-yangliu-msft]

Hi  @YunJ  ,

Displayed as 2020.06.30:

1. Put Date into Filters for manual filtering:

2. Open Show items with no data

3. Result：

The date label on the x-axis cannot be displayed completely, you can choose this:

X axis – Type –Categorical

You can downloaded PBIX file from here.

Best Regards,

Liu Yang

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

[YunJ]

hi @v-yangliu-msft 

I can't put Date into Filters for manual filtering because when other contents in slicer Store/Campaign are selected, the date will change. For example, when selecting slicer Store="LRL MU" and Campaign="38", the date shown will start from 2020.03.01 to 2020.03.15.

Thanks for your time.

[v-yangliu-msft]

Hi  @YunJ ,

You try to manually filter dates only on the  bar chart.

Best Regards,

Liu Yang

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

[YunJ]

Yes... the date on the bar chart will change based on what contents in the slicers I select... 

[amitchandak]

@YunJ , You can use all or crossfilter (with none) to remove the relationship.

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

But if you want display date still , you might have use one more table

try crossfilter(Date[Date], campaign[date],none) - add this in calculate . - refer- https://youtu.be/e6Y-l_JtCq4

In case that does work, this is approach you have to take - https://www.youtube.com/watch?v=duMSovyosXE

[YunJ]

Hi @amitchandak 

Thanks for your reply. I tried as the following screenshot. But the new measures seems like totally the same, and the date is not ended with 2020.06.30... May I know the reason?

Thanks for your time!