PBI Report Server doesn't render correct font for groups that toggle hidden fields
In paginated reports where I added groups that can be used to toggle hidden fields, the font and fontcolor of those groups is not displayed correctly. I use a XML dataset which holds the fonts and colors I want to use in my reports. When I preview the report in Visual Studio, Report Builder or SharePoint everything looks fine, but when I deploy it to SSRS PowerBI I see a font that looks like Times New Roman instead of Segoe UI that it's supposed to show. The fontcolor is black, while it should be red. It does show the correct backgroundcolor. When I do not use the dataset to render the font and just add Segoe UI in the textbox properties everything works fine. Is this a bug or am I missing something?How do I set the correct colour in the decomposition tree?
Hello, I have a question regarding the colour in a decomposition tree. I would like to create a KPI tree that should show me in colour whether I have reached the target (bar should be green) or not (bar should be red). I have created an extra variable for this, which looks like this: Color = VAR SumValue = LOG_Kosten_nach_Produkten[Gesamtkosten] VAR Target = LOG_Kosten_nach_Produkten[TargetValue] RETURN SWITCH( TRUE(), SumValue > Target, "Red", SumValue < Target, "Green", SumValue = Target, "Yellow" ) Now I have taken the field value from the variable Color for the colour in my tree. (Analysis tree -> Conditional formatting -> Colour for data bar -> Field value -> Color) Unfortunately, the correct colour is only ever displayed in the child node (rightmost node). As soon as I expand other nodes, the colour of the parent node changes to the wrong colour. If I now display all relevant variables in a table, the correct colour is displayed , even if I select a specific path in the tree (see picture). What could be the reason that the tree displays the colours in the parent nodes incorrectly? The picture shows again what the problem is. I have selected LOM 2 by double-clicking in the tree. The values "Gesamtkosten" and "TargetValue" are the same, but the colour red is displayed in the tree. In the table above, the values are the same as in the tree (also the same) and the correct colour is displayed (yellow). Why is the colour red displayed in the tree, although the values are the same and according to the logic the colour should be yellow? Thank you for your help.
Curve color depending on its position relative to another
I have 2 series of values: val1 and val2, and a column with dates. I want to show a graph with a date x-axis, and the 2 curves corresponding to val1 and val2. The 2nd curve should be red if below curve1 and green if above. The first solution I came with is to create 2 columns corresponding to val2 in my database: val2_up would have the same value as val2 if above val1, and would be NULL if below val1. Similarly, val2_down would have the same value as val2 if below val1, and would be NULL if above val1. The problem if I choose this solution is that I cannot add filters on family, category and type. Actually I could, but as PowerBI computes the total, If I choose to show for example only family1, it would compute 2 totals: the first with every values below val1 and the 2nd with every value above val1. Thus it would show 2 curves for val2, whereas I would only want 1: If you have any other idea, I would appreciate if you could share it
Default brand package RS january 2023
How can I get the default January 2023 report server branding package? With the latest update we got a new color theme for the web portal and there are only a few things I would like to change about it, but all the samples available for download have old color themes and I don't want to recreate it from scratch.
Power BI Report Server Branding
Hi, After I updated the Power BI Report server to September 2022, a new button and drop down menu appeared when the current size of the browser window is not large enough to write out the full path and report name. Until the May 2022 Version, the report name is not written out fully in case the complete path is too long, and gets cut down with "..." . This seemed to have been changed from September, as now the report name is written out completely, and the path itself is shortened to a new menu with a new button "[...]" and a dropdown for navigation, see screenshot. This only appears if the browser window is not large enough to show the full path. My issue is that i can't seem to change the color of this new button or the color of the dropdown navigation behind it. I have changed all the previuosly known json parameters in the colors file of my branding to anything but black and the button / dropdown menu still stays black. How should I change the color of this specific button? Is there a new json command that did not exist previously which is controlling it? Or is it a bug?
Lack of colours in dispersion graph (analicing differences)
Hello, In graph column using right bottom -> analyze decrease then click on dispersion graph. In desktop I can see the colours (red and green) Then I publish the report and in web versión the graph appears in white (without colours): I have tryed with differents browsers (FireFox, Chrome and Edge) and neither it works. Can you help me whith this issue? Regards.Background clolor
Hi. I have a problem. I have a column that should show different background colors. I can not do this via condition control. I have three columns. One column with Yes and No, one column with dates and a third with Datediff. I have combined the Yes and No column and the Date column into a separate column as in the picture. What I want is that if it says Yes or No and is over -14, it should be unchanged. If it says No and is between -14 to 0, the background should be yellow, if it says No and is more than 0 to Max, the background should be red. How do I fix this?? Thanks // Mattias
Color Scheme for related data points
I have two sets of related datasets. They are Fire water supply usage and Potable Water Usage. Each of these datasets have have 2 pipe sizes. What do you think would be the best color scheme to show this data on a column chart. Below is an example of the data for a couple of days. I think that the related datasets should show without looking at the legend that they are related.Network Navigator Colors Issue
When I use Network Navigator in the Power bi desktop, I create a color-coded network visualization using "Source Node Color" and "Target Node Color" fields. However, once I publish it to the report server, all colors are changed to black! I tried different web browsers and it didn't solve the issue. Any solution for this?
