Conditional formatting for matrix column headers based on closed month
Hi all, I am working with a Power BI matrix where I have months (January–December) displayed as column headers, as shown in the screenshot. no value will display, only the column Kindly ask for below request solution Dynamically change the background color of the column headers If a month is financially closed → show green If a month is still open → show grey I have a DAX in my model (e.g., a measure or flag indicating whether a month is closed): Closed Month Flag = IF( SELECTEDVALUE('Time'[IsClosedMonth]) = TRUE(), 1, 0 ) so the challenge is only related to applying the formatting to the headers. Thanks for support!
Unable to Find Visual Option in “Format Visual” Section in Power BI
Hi Team, I am trying to develop a custom combo area line chart, but I am not able to see the "visual option" in the “Format Visual” section beside “General.” Can you please tell me how I can get the visual option in Power BI Service or Desktop?
Custom authentication in PowerBI Desktop - need UniqueId or LocalStorage
Hey All, We're creating an authentication for our custom visual in PowerBI desktop -only- following along with https://community.fabric.microsoft.com/t5/Developer/How-was-authentication-accomplished-in-ArcGIS-Maps-for-Power-BI/m-p/1023081. We're use `this.visualHost.launchUrl` to trigger creation of an token, then polling the backend for the token & storing it via persistParameters. So far, so good. The problem though is that parameters are embedded in the pbix file, which means if a file is shared, so is the authentication. This is less than ideal, and so we are looking at our options for preventing this. The ideal one appears to be using Local Storage API, however this requires certification, and certification forbids queries to external sources. (Also, I recieved an 'undeliverable' notification when emailing [email protected] - is that normal?). Failing this, then the next best option would be to use any kind of identifier that is unique to the PowerBI Desktop installation. Is there anything present in the info passed to the custom visual that could be used even semi-reliably in this manner? UniqueId unfortunately is per-instance of the custom visual, and I've yet to turn anything else up that could help. Any suggestions on where to look for a UniqueID, or any kind of machine-local storage we could use?
