Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ShivaPrasad1
Helper I
Helper I

Control of Axis is not working as per the filters

Hello Team,

 

I have two visuals one is having column values(mostly 4 distinct values) as axis where as other is having time as axis. I have filter of time. As per the filter visual 2 is slicing where as visual 1 is not at all showing the data. Here I am attaching screenshots and measure expressions of the same. Please provide some approach to work the filter selection for visual 1 as well. In both visuals Y axis value is same and X axis is different. Both should be sliced accrording to slicer selection. Expected output for visual 1 is shown in first image which is showing completly blank now.

Note: Slicer selection is meant for dynamic rollback to previous 12 months.

Selected_Date = if(ISFILTERED(slicerTable[year]),if(ISFILTERED(slicerTable[month]),SELECTEDVALUE(slicerTable[Date])))

Sales_Default =
VAR SelectedDate = MAX(slicerTable[Date])
VAR CurrentDate = SELECTEDVALUE(Source[DATE])
RETURN IF(CurrentDate <= SelectedDate &&
CurrentDate > EOMONTH(SelectedDate,-12),
SUM(Source[SALES]), BLANK())

Sales_Selected =
VAR SelectedDate = [Selected_Date]
VAR CurrentDate = SELECTEDVALUE(Source[DATE])
RETURN IF(CurrentDate <= SelectedDate &&
CurrentDate > EOMONTH(SelectedDate,-12),
SUM(Source[SALES]))

Sales_Final = if(ISFILTERED(slicerTable[year])&&ISFILTERED(slicerTable[month]),[Sales_Selected],[Sales_Default])



1.PNG

 

2.PNGslicer.PNG

1 REPLY 1
v-cherch-msft
Employee
Employee

Hi @ShivaPrasad1

 

It seems you may try to create a calendar table and link it with your data table. You may refer to below post for reference.

 

https://community.powerbi.com/t5/Desktop/Show-last-13-months-based-on-user-single-slicer-selection/t...

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.