The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I currently have a slicer on my page that allows me to select the Sales Date Range.
I aslo have on my page a visual that says the Last Days Sales Amount.
The problem I'm having is that the slicer total negates my Last Day Sales Visual.
How can I obtain the SAles range from the slicer for all my visuals except the Last Days Sales Amount?
Help
if the "Last Days Sales Amount" value is the only value in the visual, you can just turn off the interactions between the date slicer and the Last Days Sales Amount visual.
If the Last Days Sales Amount is in a visual with other measures, you might try something like CALCULATE([Last Days Sales Amount measure], ALL(Date_Slicer[Date]))