Forum Discussion
Excel Slicer
Im looking to set up a Slicer which will only Highlight when all items have been received for the Job card, please see example table as follows.
so i would want JC 001 to be greyed out due to 3 items not being delivered and only show JC 097
4 Replies
OK, wow.
New suggestion: look into Power BI. It has been out for like 8 years now.
Not sure if you can do this in Excel, but seeing as this is the Power BI forum, I will give you the answer in Power BI:
Add the slicer to your report page. Then in the Filters on this Slicer section, add the [Date Received], and set the slicer to "Is Not Blank".
Hope that helps
sorry never heard of Power BI i thought this was the general help cenrtre for Microsoft, first time using this service
Hello Bethl , you are in the wrong Forum. The following is
probably what you were looking for.
Results in Microsoft 365 and Office - Microsoft Community
Please ask a new question there with an Excel Question.
