New Card Visual issue with maintaining displayed cards set in Desktop on Service
Just like the issue Power BI has had with their List Slicers (over two months going now...), the Card (new) visual suddenly today stopped maintaining the displayed card value from PBI Desktop to viewing it in the service online. If you enable set a static value of displayed cards, it only allows 3 or fewer cards (which is not at all useful). Anybody else experiencing this? If so, could someone link me the Report An Issue site please? Microsoft has the least user-friendly support of any company I've ever worked with, and I cannot for the life of me find it. Thanks in advance!
Cannot expand next hierarchy in Matrix
I found an issue in a visual in Power BI service. I have a hierarchy of Rows: Month -> Week -> FltDate. But I cannot expand to the level of FltDate. And when I try fixing it in edit mode, removing and re-inserting FltDate to the Rows, it works. But when I save the report and reopen it in view mode, everything remains, it cannot be expanded
Last non blank month with context issues
Hi! I have issue with below measure. It works when there are no additional columns that would "break down" the Actual/Plan/Forecast measure. But as soon as there is such column together in the matrix with below, the values are wrong. I've noticed it's because the NO(ISBLANK()) gets evaluated separately for every "category" it's broken down into, instead on the whole measure. Below is the representation what the measure does. . Year Period Job Category Raw Amount LastNonBlankPeriod 2023 11 Finance 5 11 2023 11 Sales 10 12 2023 12 Finance BLANK() 11 2023 12 Sales 11 12 Because Finance is BLANK in 2023, it takes period 11 into account for this specific category. Where my goal is it should always be 12 in below case as there are some values for period 12. And my values from below measure, if I remove period split will be: Finance 5, Sales 11. Instead of Finance 0, Sales 11 How can I fix the measure? Headcount Switch Yearly = SUMX( VALUES('X_Calendar Period'[F_YEAR]), VAR CurrentYear = 'X_Calendar Period'[F_YEAR] VAR LastActualsPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([Headcount By Heads])) ) ) VAR LastForecastPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([FCST Headcount By Heads])) ) ) VAR LastPlanPeriod = CALCULATE( MAX('X_Calendar Period'[F_YEAR_MONTH_NO]), FILTER( ALL('X_Calendar Period'), 'X_Calendar Period'[F_YEAR] = CurrentYear && NOT(ISBLANK([PLAN Headcount By Heads])) ) ) RETURN SWITCH( TRUE(), CurrentYear <= [Actuals Year], CALCULATE([Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastActualsPeriod), CurrentYear = [Forecast Year], CALCULATE([FCST Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastForecastPeriod), CurrentYear = [Plan Year], CALCULATE([PLAN Headcount By Heads], 'X_Calendar Period'[F_YEAR_MONTH_NO] = LastPlanPeriod), BLANK() ) )
Dynamic Format not working with Durations
In my reports, I use durations in seconds for various metrics. It is handy to create visuals and make calculations, but when displaying the values, users prefer to see "hh:mm:ss" instead of the number of seconds. I convert the durations to part-of-day decimal and use FORMAT() to display it as "hh:mm:ss" or "nn:ss" if less than an hour. But this does not work with dynamic formating: although i return a text string containing the appropriate format, it is handled as text instead of being applied to the decimal value as format stirng. So, how can i use dynamic formatting to apply the appropriate format string to a duration? The .pbix demonstrates the issue with a simple example (it's in weTransfer, can't upload here yet): https://we.tl/t-gdqaD1nf3d Thank you, Nikos
Bug / issue with position of shape when publishing to workspace and app
Hi, I'm struggling with a bug in my reports. I have published a report through the App in the service, but for some users some of the lines (shapes) in the report are offset. This applies to only one matrix in the entire report. I've has faced various challenges: User gets all lines in the array wrong. A user gets the same presentation of the report as me (in chrome) on their Laptop and on a 27 inch external monitor. If he looks at the report on a 25-inch external display, the lines are incorrect on the matrix. I get the user to open the report in the service and edit the report so that the lines are right for him and then publish in the app. Then the lines appear in the wrong positiong for me - both in the workspace and in the app. I've tried to group the lines with the matrix, lock the position and re-create the matrix from the start - but the same error comes every time. Is there anyone who has been through this before and who has any tips?
Stop Parameter container from hiding when returning from child report
Hello, We are displaying SSRS reports in Power BI Report Server. Few reports have child reports created, now, after opening the child report and pressing the "Go back to parent report" button (to left of zoom drop-down), I will be taken back to the parent report, but the Parameter container will be hidden. Is there a way to keep it always visible? Is it something that can be controlled from SSRS?
