I can't believe that this idea has not been implemented. The inability to conditionally format values with the SWITCH function is a severe limitation on what would otherwise be a very elegant and useful reporting function.
Thanks for your votes and comments! We’re building out our email subscriptions feature in the Power BI cloud service. For example, today, you can subscribe only yourself to a report, but we’re working on enabling you to subscribe other people as well. There are also some technical barriers to integrating the current implementation into an on-premises server. Once it’s a little further along, it’s something we’d love to bring to Power BI Report Server. For now, consider it on our backlog.
Most organizations have power users who will go to the PBI Service and review the necessary reports and other users who will never read anything unless it is pushed right in front of them. That is why it is critical for administrators to have the ability to enter email subscriptions to send reports to other users. Looking forward to having this implemented!
If you were at our Microsoft Business Applications Summit, you might have seen Amir and Will demo this feature! We are actively developing it now, and while we do have some more work today before it releases, the release isn’t too far off in the future. You can watch the session they demoed it in here: https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-204
This would add tremendous utility to the Matrix visualizations!