Power BI Report Server - Hierarchy Axe Y impossible on bar graph
Hello everyone, Sorry for my approximate technical English, I hope the exposition of my problem will be understanding. Here is the version of : - my PowerBi Destock: Version: 2.109.1021.0 64-bit (September 2022) - my PowerBi Report Server: Version1.15.8377.1837(September 2022) I have a problem to go down in the data hierarchy on my Y axis in my PowerBi Report on a bar chart. On my PowerBi Destock : When setting up my bar chart, I defined a hierarchy for the Y axis based on a date table. On my chart, I can go down from month to week to day as set (on the top right corner). On my PowerBi Report : Once my PowerBi is online, when I open my PowerBi, I can't access the option to go down the bar chart (nothing on the top right corner). FYI, on a curved graph, I don't have this problem (with the same configuration). => Do you have any idea of the solution ? Thanks in advance for your help, Regards, Thomas
Ranking with hierarchy levels for bottom 25%
I am very new to Power Bi, I am currently having trouble to create a ranking for Bottom 25% employee. There are 3 levels of the Hierarchy: Directors, LM, and employee. I would appriciate if anyone would able to help me on this. I've tried multiple ways but it have not give me the desire result. I would like it to display any employee who has less and equal 25% and wont show any 0%/ blank value. NAME ---------------------RANK Director 1 ----------------- 1 LM B 1 EMPLY BB 1 LM A 2 EMPLY AA 1 LM C 3 EMPLY CC 1 EMPLY CCA 2 Director 2 2 LM H 1 EMPLY HH 1 I have tried the 2 following but its not given the result that I am desired: Rank by CBTs = RANKX(ALLSELECTED('Employee'[DIRECTORS],'Employee'[LM],'Employee'[EMPLY_NM]), [CBTs% Filter],, DESC) CODE 2: _CBTs Ranking = VAR _Director_Ranking = SUMX( ADDCOLUMNS( SUMMARIZE( Employee, Employee[Directors] ) , "@Directors RANKING", RANKX(ALL(Employee[Directors]), [CBTs %], , DESC ) ) , [@Directors RANKING] ) VAR _LM_Ranking = SUMX( ADDCOLUMNS( SUMMARIZE( Employee, Employee[LM] ) , "@LM RANKING", RANKX(ALL(Employee[LM]),[CBTs %], , DESC ) ) , [@LM RANKING] ) VAR _Tech_Ranking = SUMX( ADDCOLUMNS( SUMMARIZE( Employee, Employee[EMPLY_NM] ) , "@EMPLY RANKING", RANKX(ALL(Employee[EMPLY_NM]), [CBTs %], , DESC ) ) , [@EMPLY RANKING] ) VAR _Results = SWITCH( TRUE(), ISINSCOPE(Employee[EMPLY_NM]), _Tech_Ranking, ISINSCOPE(Employee[LM]), _LM_Ranking, ISINSCOPE(Employee[Directors]), _Director_Ranking, BLANK() ) RETURN _Results Thank you so much!
