Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi Experts,
i need help with 2 things
1) below is the view of the dashboard, 1st support is whenever i select End of Week or End of Month, it should show only Current Week and Past 5 weeks Values and Current Month and Past 5 Months based on the Dropdown selection, it should be dynamic
2) also i see my Card Values and Bar graph values are not changing based on the Dropdown Selection made, seems like a Measure or Dax issue. thank you for the help and support
here is my pbix file
https://drive.google.com/file/d/1EP3BMNtm3ueuFrl0V9a_S5QB_tDXWas6/view?usp=sharing
any help on this is highly appreciated
@vinodDrinkPak , Create an independent date table and create these two measures with help of that
//Date1 is an independent Date table, Date is joined with Table
5 month =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = eomonth(_max, -5) +1
return
calculate( sum(sales[Gross Sales]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
//Date1 is independent Date table, Date is joined with Table
5 week =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -5*7
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))
you can use that visual with week or month connected date 1
Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI
Also, you can use a create field parameter with week end date and Month End Date from date table swap measure
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf
wow Fantastic!! you are pro!
only thing it doesn't do is (End of month, End of Week Dropdown) it doesn't filter my card value and Bar graph
i am using the below measure to display my card and graph values
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |