Hi,
Is there a way wherein the values in the left circles will only show if the dates in the second circles will only be in May?
//NT
1 ACCEPTED SOLUTION
Hi @tksnota ,
According to my understanding , you want to achieve a simple filter.
There are many filter methods in Power BI , such as Filter pane , Slicer and DAX measure.
1.User Filter pane:
You can drag the Month field under the Date Hierarchy to visual level Filter , then select May directly:
2.Use Slicer:
3.Use DAX measure:
May filter = IF(MONTH(MAX('Table'[Project Start])) = 5 ,1 , BLANK())
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tksnota ,
According to my understanding , you want to achieve a simple filter.
There are many filter methods in Power BI , such as Filter pane , Slicer and DAX measure.
1.User Filter pane:
You can drag the Month field under the Date Hierarchy to visual level Filter , then select May directly:
2.Use Slicer:
3.Use DAX measure:
May filter = IF(MONTH(MAX('Table'[Project Start])) = 5 ,1 , BLANK())Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @tksnota
Use the filter/slicer by the project start date?
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
