Sort stacked column by metric in Tooltip
Hello - I would like to sort the Job Functions in each column by the metric in the tooltip (Labor Minute) from smallest to largest. In other words, I would like the Job Function with the lowest Labor Minute at the bottom of the column and the Job Function with the largest Labor Minute at the top. I thought that since Labor Minute was in the tooltip, I would be able to sort the column on that metric, but it is not giving me that option. Is this request possible? Thank you,
HELP: problem with What if parameters
Hi everyone! I'm trying to use a What if parameter for a stacked bar chart but I'm not able to do it. On Excel this was the result: It was made with a row for each hour, each hour has 3 values: delivery time, charge time, rest time (transparent color) All the row where mad to have always 60 (minute) as sum In Power BI I've made all the dax formula and I have for each hour the 3 number I need: delivery time, charge time, rest time. My problem is that all this numer came from a DAX formula and not from a table (Query) because they are directly made having some calculation starting from a What if parameter. I'm able to have a stacked bar chart for 1 hour, but when i try to insert another hour (and I expect to have two different rows (made each one with the three values)) I have each time only one row. This problem I think is why I cant get a Y axes data table, like all the hours subdivisions. I already tryed to make a table with all the hours but i cant connect with all the DAX formula, as saying: all this three DAX formula are relatet to hour 8pm, all these three are for 9pm, ..... In this case I shoul be able to have how many rows as all the hours (each one stacked with the three numvbers). Please really need help cause I'm getting really crazy! Thank you so much
Visual using secondary axis but secondary axis is turned off
I have a line and stacked column chart and all values are using the primary axis because they are on the same scale. Just recently we have tested an upgrade to May 2020 Report Server and I noticed that the visual in this test version is using the secondary axis for the line and the zeros are not aligned on primary and secondary making the value for the line higher than the value on the primary axis--note the secondary axis is not displaying. On desktop, it displays correctly and still displays correctly on our older version production site. I do not want to display the secondary axis and have not been able to figure out how to fix this but need to do so before we move the new version to production. Any thoughts?Stacked column and Line in one single chart in Power BI Paginated Report
Let's suppose this is our dataset: We need a stacked column with a line representing the aggregation of the values for each column. With only the areas we manage to generate it: However when we add the values column in the series group section we are getting a line for each level present in the chart: Is it possible to generate this type of charts ? How can we indicate that the line should be present in each column making reference to the total by area?Adding 2 custom lines to line and stacked column chart
I currently have a pareto chart by number of cases per event date. I'm trying to add a rolling 7 day average calculation to this but I keep getting: Where I was hoping to have something like this? I'm currently running my 7 day rolling average by [Event Date]: 7 Day Rolling Average - Notification Date = CALCULATE(SUM('Sheet1'[Epi Date Count]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) / CALCULATE(DISTINCTCOUNT('Sheet1'[Event Date]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) Is there any way this can be done? Thanks in advance Please find file attached https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0
