Latest Enterprise DNA Initiatives

Filters Turning Off When Publishing to Power BI Service

Hi,

I’ve got a report that I run for a client every month. This month, something odd has happened to one of the pages. The page was added last month and worked fine. It includes some data that was only available from November, so I have filtered out all data from prior to November so that the results aren’t skewed and the visuals make more sense. Last month I filtered out all dates except Nov - Feb. Now, after March month end, I have extended the range to Nov - Mar. On Power BI Desktop, everything looks and works as I want it to, however when I publish to the Power BI service, the filter range is on in some instances and off in others. I’ve attached two screen shots so you can see the differences:

  • The Power BI desktop only shows Nov - Mar as I want it to on the bar graphs

  • The Power BI Online Service shows all months for two of the three graphs whilst displaying the third graph (top left hand corner one) as I want it to

In addition to these, if I select March as the month using the slicer, two cards on the left (Hrly Wage Cost and Hrly Rate Earned) display BLANK in the online service whereas desktop shows the correct numbers. Again, this is because the filters I put on those visuals in Desktop are not holding in the Online Service.

Can anyone shed any light on why the Online Service is doing this please? I’ve also edited the report in the Online Service to put the filters back on and saved my edits. However, once I go back into reading view, my edits have gone again.

Oh … and yes, I know the numbers between the online and desktop version for some visuals are different. That’s for a similar reason i.e. I’ve filtered out a temporary contractor in one version and in the other, that filter is also dropping out.

Any ideas?

Hi @5thGreen, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.
  • When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.

image

  • Use the proper category that best describes your topic
  • Provide as much context to a question as possible.
  • Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

Hi @5thGreen, we’ve noticed that no response has been received from you since the 6th of April. We are waiting for the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details. In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.