Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello Everyone,
I am very new to Power Bi and DAX.
I want to know or my goal is if user clears all slicers or opens the dashboard, untill any specific selections are made, the line chart should plot most recent product ran for past 3 days based specific shape, grade and size based on latest date.
Pic of my Dashboard for refrence
and pic of my table connections for refrence as well
My data set contains Date&Time,Department,Mill Lot, Heat Number, Grade,Shape,Size, Yield,Tensile,Elongation
Based on Department i have 2 value tables (Mechanical Data-1 and Mechanical Data2).
If you notice on the dashboard, i have Slicer Mechanical Properties on dashboard that basically plots either yield, tensile and elongation value field based on user selection of grade, shape and size lookup slicer from main table.
I am trying multiple approaches, another approach is when all slicers are cleared the date slicer which has recent product field is always on, so that the chart refers to that field, but i am having no luck with that code either.
So any help/advice would be greatly appricited.
Thank you,
Maz
@Maz_1991 , We can isfiltered to display something after selection
refer video from Guyinacube: https://www.youtube.com/watch?v=sXn-QZqLD-8
To clear all slicer , you use clear all slicer button
Power BI March 2023 Apply all Slicer, Clear All Slicer Buttons: https://youtu.be/tfQT31AZEoY
Or create a parameter page to force user selection
Power BI Abstract Thesis: Need Traditional Parameter Page: https://www.youtube.com/watch?v=F3qMwQtWjvo&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=15
New means to access display pages - Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |