Forum Discussion

fibaek's avatar
fibaek
Icon for Helper I rankHelper I
5 years ago

Display dimension in tooltip based on slicer selection

Hello, I have a report based on a live connection to a PBI Dataset. In the report I have a clustered column chart with a tooltip that displays further details. There is a slicer on the page that all...
Need Help
fibaek's avatar
fibaek
Icon for Helper I rankHelper I
5 years ago

Hello MFelix,

 

Thank you once again! Your solution is close to being exactly what I am trying to do. The users will typically select a region – either directly through the slicer or be restricted through RLS – and then potentially one or more BUs. In case of no selection the user should see the regions – not the SBUs - in the table, and if both region and BU is selected it should act as if only BU is selected. But other than that it is absolutely perfect! I have tried playing around with some logical NOTs but haven’t quite been able to nail it because BU is included in the tooltip. Any input would be highly appreciated!

 

It seems like the measure for formatting is not needed? I just added another measure and did conditional formatting on it. Looks just fine.

 

Link to .pbix on OneDrive: https://1drv.ms/u/s!AmZ2f-AI5Q3zgYsQLvmSZyPrF_t1gg?e=Efpqre

 

Thanks,

/Sune