User Profile
jazzhanya
Frequent Visitor
Joined 8 years ago
User Widgets
Contributions
Relative Date Slicer added through Power BI Service doesn‘ work
Hello, The relative date slicer doesn't works well if it is added through "Edit Report" in Power BI Service. I cannot make any selection in the slicer's dropdown lists. But if the same slicer is added through Desktop, it wroks well. I think this is a bug. Would you please help check it and give me some feedback? Thanks, ZhanyaRe: Can't view the embedded report in SharePoint
Thanks Frank for your reply. Could you please tell me does the user with the issue have an explicit access to the O365 group and are they a Security Group or User List? Yes, we have explicit access to the Office 365 group and the SharePoint website is an open source within the user group. It seems Power BI Service in SharePoint page is not stable. Sometimes I can see the Power BI content but sometimes not. And I have been using the same browser to view the page. Does this user can open the report in Power BI Service ? Yes, the content works well in Power BI Service website. Additionally, if I open this SharePoint page with SharePoint app in my mobile, I can view the Power BI content. How did you share the report to users? I used the "Share Report" button in Power BI Service. But even I'm the Power BI dashboard admin, I can't view the SharePoint Page either. If you have any idea, please let me know. I will appreciate it a lot. Kind regards, JazCan't view the embedded report in SharePoint
Hi everyone, I can't view my Power BI report in SharePoint page anymore after I re-published it to Power BI workspaces last Sunday. The SharePoint (embedded) page returns me blank content. It seems only the SharePoint admin can view the report. This report is stored in Power BI workspaces. I'm the workspaces admin and I created the SharePoint embeded link. It worked well for everyone with the same browser before my last re-publish. Can you please advise on how to solve this issue? Many thanks, JazRe: Empty visualization images with no data displayed in Power BI Server
Hi Philip, Thanks for your reply. I try restart the server but it doesn’t work. And yes, I do schedule a daily data refresh on the server. I can view the data again in the report server, if I manually re-publish the file from Desktop. However the data will disappare after a short while. Can you please advise how to solve this problem? Kind regards, JazEmpty visualization images with no data displayed in Power BI Server
Hi everyone, I'm facing a trouble when I publish my pbix. file from Desktop to the Power BI Server. The visualization image can be loaded but there is no data available in every dashboard. Here I attach an screenshot.. The data could be displayed before in the same dashoard. This problem started to happen 1 week ago. I can see the data in the report in the file in Power BI Desktop. Data source is SharePoint Online list I published it to both My Workplace and App Workplace, but they both return empty I tried both Edge and IE browsers, but I faced the same problem. One time I published it to the Server, the data was displayed but after I refreshed the webpage, it disappared again. Would you please help check what's the problem? How can I fix it? Thank you very much in advance! Kind regards, JazRe: After a scheduled refresh the report has no data
Hi everyone, I’m having the same trouble with my dashboard. It started to happen 1-2nweeks ago. I can see all the data shown in the reports with Power BI Desktop. But I cannot see any data shown in the same reports with Power BI server. If I re-publish the pbix. file to the server (i tried both my workplace /app workplace) then I can see the data in the reports again. But if I refresh the server page, all the data disappeares..Re: Display KPI Light Last Month Status in Report Table
Hi v-jiascu-msft Thank you for your support! If I reduce the formula to show Year & Month - 1, I will lose the visibility of those supplier sites whose last update are before June. Please see my screeshot below, the supplier site "Hanau" as an example. I'm think to add another condition to my last formula: LastMonth = IF( YEAR(TODAY ( ) ) = YEAR ( 'SM KPIs' [Month-Year]) && MONTH ( TODAY ( ) ) -1 = MONTH ( 'SM KPIs' [Month-Year] ); 1; IF ( YEAR( TODAY ( ) ) = YEAR ( 'SM KPIs' [Month-Year] ) && MONTH ( TODAY ( ) ) -2 = MONTH ( 'SM KPIs' [Month-Year] ); 1; IF ( YEAR(TODAY ( ) ) = YEAR ( 'SM KPIs' [Month-Year] ) && MONTH( TODAY ( ) ) -3 = MONTH( 'SM KPIs' [Month-Year] ); 1; BLANK ( ) ) ) ) My thought is to add an additonal formula.. for each supplier, sumlastmonth = sum ( 'last month' ) If sumlastmonth = 3, return Year & Month -1, If sumlastmonth = 2, return Year & Month -2, If sumlastmonth = 1, return Year & Month -3, else blank The problem of this formula is that if the last update of the supplier site is before April, no KPI light will be displayed. Can you please advise on it? Thank you!! Kind regards, JazRe: Display KPI Light Last Month Status in Report Table
Hello Sorry for my late reply. I changed the KPI light pattern format into traffic light.. The traffic light color is correct. My problem here is I want to present only the last "Month-Year" KPI status of each supplier site. (please see below screenshot) In the data, not all the supplier sites has the up-to-date data ( in this case last month is 2018-06). Some might have the last record in last month-1 "2018-05", last month-2 "2018-04" or evern earlier ( an exemple below is the supplier site Hanau). Here is the formula I write: LastMonth = IF(YEAR(TODAY())= YEAR('SM KPIs'[Month-Year]) && MONTH(TODAY())-1 = MONTH('SM KPIs'[Month-Year]);1;IF(YEAR(TODAY())= YEAR('SM KPIs'[Month-Year]) && MONTH(TODAY())-2 = MONTH('SM KPIs'[Month-Year]);2;IF(YEAR(TODAY())= YEAR('SM KPIs'[Month-Year]) && MONTH(TODAY())-3 = MONTH('SM KPIs'[Month-Year]);3;BLANK()))) But the problem of this formula is .. it will present last month, last month-1, and last month-2 data at the same time. And I only want the report table to return only one line of the last record status for each supplier site. Can you please advise how I can solve this problem? Thank you! JazDisplay KPI Light Last Month Status in Report Table
Hi everyone, In my data, I have one column called "Year/Month". I want the last table column (marked in red) shows the last "Year-Month" status of Overall RAG color (makred in blue) with the following logics: Green as Overall RAG: Amber as Overall RAG: Red as Overall RAG: However, the colume doesn't return me the correct faces for the last status, as shown in the picture. I also tried to use conditional color formating instead of smile face, but it didn't work either. Can anyone help on my case? Thank you in advance!!
