The secure embed option works for reports that are published to the Power BI service.

The user needs to sign in to view the report whenever they open a new browser window.

Some browsers require you to refresh the page after sign-in, especially when you use InPrivate or Incognito modes.

You might encounter issues if you use unsupported browser versions. For a list of browsers that Power BI supports, se

This solution cannot be used when the last date to consider is dynamic (for example because it is different for different measures). However, if it is possible to create one calculated column for each related fact table that may have a different range of dates to consider, doing so is still a good idea. Every measure will use the flag in the Date table corresponding to the proper fact table. For example, a DatesWithSales flag can be used in Sales measures, whereas a DatesWithPurchases flag can be used in Purchases measures.

Public Function GetSelectedSlicerItems(SlicerName As String) As String
Dim SL As SlicerCacheLevel
Dim sI As SlicerItem

Set SL = ActiveWorkbook.SlicerCaches(SlicerName).SlicerCacheLevels(1)
For Each sI In SL.SlicerItems
If sI.Selected = True Then
GetSelectedSlicerItems = (sI.Value)
End If
Next
End Function

Dim sValue As String
sValue = GetSelectedSlicerItems("Slicer_HeaderTitle")