Forum Discussion
Multiple Sections or Select All in Filter Slicer Not Displaying Column Values
Hi Palan22 ,
According to your description, I create some data:
Here are the steps you can follow：
1. Create calculated table.
Service = CALENDARAUTO()2. Create calculated column.
Month = FORMAT('Service'[Service Date],"mmm")Month = FORMAT('Goals'[Goal Date],"mmm")3. Create measure.
Target Goal Per Month = var _select=SELECTEDVALUE('Service'[Month]) return CALCULATE(MAX('Goals'[DOS]), FILTER(ALL('Goals'),'Goals'[Month]= _select && 'Goals'[Status] = "Completed"))4. Put [Status] in Filter and select Completed
5. Result:
When choosing ALL,
When choosing May,
If this result does not meet your expectations, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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.
Super UserPalan22 Hey ,
You can create a new month name coloum from service date .
use below formula to create a col.
month year name = format(tablename[servicedate],"Mmm-YY" )
drag the coloum as slicer then try to slice and dice report .
if you are using date table create a relationship in between both table . ( if you have correct relationship active)
if not create a key for defining relationship.
if you find it useful then Kudo will aprriciated and accept the solution .