Forum Discussion
Show Only Values Based On Date & Year
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
Hi Anonymous ,
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.
2 Replies
- Ritaf1983
Super User
Hi Anonymous
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.
Hi Anonymous ,
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.
