Power BI table dynamically expand JSON
I am in need of a Table custom visual that dynamically expands JSON content. For example for an input like this { "Column 1": "Value 1", "Column 2": "Value 2", ... } The table will expand this to two columns and display the values underneath This has to be dynamic, and allowing all the normal table features: sorting, conditional highlighting, ...
Power BI Report Server Branding Issue
Server Version: 1.20.8926.40580 (May 2024) Issue: A while back we investigated changing the branding on the server using the Multicolored example brand zip file seen here. After creating the new branding package and successfully deploying it we noticed that one element refused to change with the new branding colours ("Primary" and "PrimaryAlt") which shows as #117865 (dark green) instead of #e71f85 (pink) Reverting the server back to default branding doesn't alter it either, as if the link between the two is broken. Once reverted back you can see the green remains. All the elements in the json file were accounted for to make sure this colour wasn't in there. Here's the JSON: "name":"Multicolored example brand", "version":"1.0", "interface":{ "primary":"#e71f85", "primaryAlt":"#ffffff", "primaryAlt2":"#0080c9", "primaryAlt3":"#009ad4", "primaryAlt4":"#ffffff", "primaryContrast":"#000000", "secondary":"#0c499c", "secondaryAlt":"#0c499c", "secondaryAlt2":"#0080c9", "secondaryAlt3":"#ffffff", "secondaryContrast":"#ffffff", "neutralPrimary":"#F2F9FE", "neutralPrimaryAlt":"#ffffff", "neutralPrimaryAlt2":"#b1d7ee", "neutralPrimaryAlt3":"#0c499c", "neutralPrimaryContrast":"#0c499c", "neutralSecondary":"#F2F9FE", "neutralSecondaryAlt":"#ffffff", "neutralSecondaryAlt2":"#ffffff", "neutralSecondaryAlt3":"#e71f85", "neutralSecondaryContrast":"#000000", "neutralTertiary":"#ffffff", "neutralTertiaryAlt":"#ffffff", "neutralTertiaryAlt2":"#ffffff", "neutralTertiaryAlt3":"#ffffff", "neutralTertiaryContrast":"#000000", "danger":"#e60000", "success":"#3fae29", "warning":"#ffd000", "info":"#0c499c", "dangerContrast":"#ffffff", "successContrast":"#ffffff", "warningContrast":"#ffffff", "infoContrast":"#ffffff", "kpiGood":"#3fae29", "kpiBad":"#e60000", "kpiNeutral":"#ffd000", "kpiNone":"#0c499c", "kpiGoodContrast":"#ffffff", "kpiBadContrast":"#ffffff", "kpiNeutralContrast":"#ffffff", "kpiNoneContrast":"#ffffff", "itemTypeIconColor":"#ffffff", "reportIconBackground":"#009ad4", "excelIconBackground":"#009ad4", "folderIconBackground":"#009ad4", "datasetIconBackground":"#009ad4", "otherIconBackground":"#0c499c" } } Another poster had a similar issue which was fixed when they upgraded their version of report server to the January 2023 Release. Since our version is newer (May 2024) that hasn't resolved it. Any ideas where to go next? Thanks in advance Tim SOLUTION: Added this additional code to the colors.json file. "primaryButton": "#bb2124", "primaryButtonHover": "#d31115", "primaryButtonPressed": "#3d0000", "link": "#d31115", "linkHover": "#671215", "linkVisited": "#3d0000", "radioButtonCheckBox": "#bb2124", "radioButtonCheckBoxHover": "#d31115"Deneb (Vega-Lite Power BI) - Conditional Tick Mark removal?
Deneb noob here & working with a user who wants to see if tick marks can be removed where there is no label in deneb? We also want to keep the max amount of gridlines possible. Before After I tried using the conditional labels/located in the documentation, but could not get my expression to respect the labels in the chart above.Using JSON to Format Text Boxes
I'm running into an issue when trying to edit the JSON file for my powerBI report. I have a solid file, however, I am unable to edit the formatting for text boxes in the file. I found a solution from 2021. However, it seems to no longer work with the 8/2023 version of PowerBI. Would anyone have a code snippet they are willing to share? "textbox": { "*": { "*": [ { "fontSize": 14, "fontface": "Arial", "color": "#333333" } ], }}Report-Name color not using our branding
Hi all After updating our Power BI Server On Premise we have the problem, that the report names are not displayed in the color we defined in our branding json-file. After the update the color is now #0C695A: What we have to define in the branding json-file to overwrite this color #0C695A? Thanks, kind regards Pierre
New Shapes in PBI - How to Setup JSON?
Hi There, with the may 2021 release of PBIRS we also got the new shapes feature with desktop which was released to the regular desktop in april 2021 (https://powerbi.microsoft.com/de-de/blog/power-bi-april-2021-feature-summary/#post-14480-_Toc68689097). Unfortunately after converting existing shapes my settings in my custom json don't work properly anymore. Is there any updated documentation to this? This (https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-report-themes#report-theme-json-file-format) does not help at all... Cheers AxelCan't turn off data labels once they have been set to 'show: true' in JSON file.
I am working on a JSON file for a custom theme for Power BI. For some of the visuals I have set that data labels should be on. However when I import the theme, I can't manually change this setting in the desktop version. So if I have set the data labels to be on in the JSON file, I can't turn them off manually in desktop version of Power BI. The reverse also happens. If I have turned data labels off in the JSON file, they can't be turned in manually in Power BI. It's only an issue with Data labels. Fx I can turn Total labels and Series labels on/off as I want no matter the settings in the JSON file. The only work-around I found is to go into Data Labels > Apply settings to > and then choose each series and turn off data labels for the series I want. However this is not feasible in settings, where there are many series. I would like to be able to choose whether the Data Labels are on or off by default, but I still need to be able to change it in Power BI for some specific cases of data. Is this a general thing, or is it something specific in my JSON file? I provided an example of the 'labels' section of the JSON file below: Don't know if I should provide the entire JSON file here, as it is quite long? "labels": [ { "show": true, "showSeries": true, "color": { "solid": { "color": { "expr": { "ThemeDataColor": { "ColorId": 0, "Percent": 0 } } } } }, "labelDisplayUnits": 0, "labelPosition": "Auto", "enableBackground": true, "backgroundColor": { "solid": { "color": { "expr": { "ThemeDataColor": { "ColorId": 6, "Percent": 0.2 } } } } }, "backgroundTransparency": 0, "labelOverflow": false, "showAll": false, "fontSize": 8, "fontFamily": "Arial" } ]
Relative Path to fix JSON import and allow auto refresh
Hi All, After much research and reading a lot of posts I was able to use a base code and adapt it to my PBi needs, the current code merges all pages on a JSON but I am unable to refresh the database automatically due to PBi detecting the authoring query being already dynamic. I read that using [Relative Path = ] fixes this problem, however every time that I try it I get different type of errors. Would anyone be so kind as to fix my current code or help me understand how should I face this problem? Many many thanks, let BaseUrl = #"API URL",, ApiKey = #"API Key", EntitiesPerPage = 10000, GetJson = (Url) => let Options = [ Headers = [ #"accept" = "application/json" ] ], RawData = Web.Contents(Url, Options), Json = Json.Document(RawData) in Json, GetEntityCount = () => let Url = BaseUrl & "&$count=true&$top=0", Json = GetJson(Url), Count = Json[#"@odata.count"] in Count, GetPage = (Index) => let Skip = "&$skip=" & Text.From(Index * EntitiesPerPage), Top = "&$top=" & Text.From(EntitiesPerPage), Url = BaseUrl & Skip, Json = GetJson(Url), Value = Json[#"value"] in Value, EntityCount = List.Max({ EntitiesPerPage, GetEntityCount() }), PageCount = Number.RoundUp(EntityCount / EntitiesPerPage), PageIndices = { 0 .. PageCount - 1 }, Pages = List.Transform(PageIndices, each GetPage(_)), Entities = List.Union(Pages), Table = Table.FromList(Entities, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(Table, "Column1", {"Id", "Department", "LoginName", "Title", "Email", "IsDeleted", "UserFieldValues"}, {"Id", "Department", "LoginName", "Title", "Email", "IsDeleted", "UserFieldValues"}), #"Expanded UserFieldValues" = Table.ExpandListColumn(#"Expanded Column1", "UserFieldValues"), #"Expanded UserFieldValues1" = Table.ExpandRecordColumn(#"Expanded UserFieldValues", "UserFieldValues", {"Value"}, {"UserFieldValues.Value"}), #"Renamed Columns" = Table.RenameColumns(#"Expanded UserFieldValues1",{{"UserFieldValues.Value", "EDM_ID"}}) in #"Renamed Columns"
