The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone - I'm working on a project to display some Power BI reports in a dashboard. This dashboard is then dislpayed through MVix in our office display (65" TV's set up at various locations thoughout the office). Normally tweaking colors of fonts would just be done via normal formatting, but with what I'm attempting it's all wrapped up in 1 measure to display multiple things.
the measure DAX looks like this:
I'd like all the font to be in white, with the exception of the Countdown of days remaining part of the measure to be in another color.
Is this possible? I've thought about constructing a conditional formatting measure, but i'm not sure if it will work for part of the measure and not all the measure.
Solved! Go to Solution.
@jsfuhrman Could probably be done as an SVG graphic. Probably could be done in Deneb as well. Or, maybe go with an HTML Content visual.
@jsfuhrman I don't believe that will work. I would create 2 measures, one for the countdown number and then the other one that you have. Overlay another card visual on top of the original one with a transparent background, put your counter in there and then color it the color you want.
If the end result were to present in Power BI service, that would totally work. Unfortunately with MVix displays, it only works with a PBI Dashboard, so i've got to take a visualization, pin this to a dashboard, then connect that dashboard to an MVix media feed. its a cumbersome process. I might explore bagging MVix and just using a raspberry Pi as the display unit - as i think i'd have much more freedom for displaying things.
I did try passing a Custom Formatting measure and use this measure in the Conditional formatting... it works with 1 value passed, but not multiple values passed - which i suspected was the case, but thought i'd try. Mostly just posting in case these ideas help someone or provides some samples of things to try for their needs. I wonder if its possible to use DAX to pass some underlying json code or something. Just kindof thinking outloud.
This works:
This Does not work:
@jsfuhrman Could probably be done as an SVG graphic. Probably could be done in Deneb as well. Or, maybe go with an HTML Content visual.