Decomposition tree sort value Desktop vs Server changing
Hi There, My issue is very simple. When I publish a report on PBI server, the sort applied to a decomposition tree (Descending by value) is not respected and instead it sorts descending alphabetically. Desktop: Server: What I tried: - Check a similar post on the community: https://community.powerbi.com/t5/Service/Decomposition-Tree-has-no-default-sort-on-my-online-report/m-p/1206762#M101791 This does not apply to my issue as I do not want to sort the values on the dataset. - Revert to default on the server. It doesn't work, the sort alphabetically is the default on the server - Edit on the server and Sort but the only option is an Alphabetical sort: Did anyone run into this issue before? Regards, Alex
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.Bookmarking collapsed Decomposition Tree Desktop vs. Server
Hi - Found an issue with how the Decomp Tree visual is bookmarked in Desktop vs. published on Server. On Desktop, the bookmarked visual opens as expected: completely collapsed. On Server, the bookmarked visual opens with 5 fields already selected (the first field locked and 4 others unlocked). Screenshots attached. This issue does not come up when I open an un-bookmarked Decomp Tree on the Server. Could someone please help? Desktop Version: 2.102.683.0 64-bit (February 2022)Measure not changing value with decomposition tree
Hello, I need some help. I have a measure which is calculated as Realization = DIVIDE([Net Revenue],[Production]) The above two factors contributing to Realization are caluclated as Net Revenue = [Production]+[Variance]+SUM('star factWIPProvision'[Amount]) Production = SUMX('star factWIP',IF(ISBLANK('star factWIP'[TimeProduction]),0,'star factWIP'[TimeProduction])+IF(ISBLANK('star factWIP'[ExpenseProduction]),0,'star factWIP'[ExpenseProduction])+IF(ISBLANK('star factWIP'[JobTypeAllocationProduction]),0,'star factWIP'[JobTypeAllocationProduction])) The Variance is Calculated as Variance = SUM('star factWIP'[WriteUpDownAmount]) Now my question is I am using a decomposition tree to see the realization value across different hierarchy but the value doesnt change, its showing same across all hierarchyDecomposition Tree - No scroll bars when published to Report Server
hello, I've seen: https://community.powerbi.com/t5/Service/Decomposition-Tree-visual-scroll-issue-in-Power-BI-Service/td-p/1061417 and https://community.powerbi.com/t5/Report-Server/No-scroll-on-Decomposition-Tree/m-p/1167781#M14659 Does anyone know if and when the scroll bars for the Decompoisiton Tree dissappearing when PBI report published to Report Server might be fixed?No scroll on Decomposition Tree
Hello, We are currently using Power BI Report Server May 2020 (Build 15.0.1103.227). I know build 232 exists but there is nothing in the change log about this issue and we haven't deployed it yet. In Power BI Desktop, when using a Decomposition Tree with a dimension with many elements there is an arrow to scroll: However when I upload this same report on Report Server there is no arrow. I have tried with IE, Chrome and Firefox, same behavior with all browsers. I've tried to reduce the height of the visual in case the arrow was created outside the page but it didn't help. You can see that there are many more lines going down in the second screenshot. It seems like it's rending the whole thing without realising it's running out of space. Anyone else encountering the issue? Thanks!
