cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

How to surpress one imported value without manual work

Hello everybody,

 

is there a reasonable way of how to surpress a specific value without filtering in PowerQuery in the background? And not using a slicer/filter?

 

The issue is the following: I have an automated data import from SAP. It creates one datapoint per day and at the end of the week, the final stand from Friday is saved as final version.

 

I set up a report that plots everything against charts and so on. But as the data import goes on, the charts plot the "unstable" data from the current week to the charts too (i.e. filter is like "select all", otherwise I have to deselect the latest version what i don't want to do). Example, I have Versions:

 

1,2,3,4,5 imported automatically, but I only want to see 1,2,3,4. I need sth. like "surpress the max. number" automatically. 

The reality is a bit more complicated as it is not always a 5...but more like 2014, 2115 and so on....but I am just interested in a best practice.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII
Super User VII

Re: How to surpress one imported value without manual work

@NovaBI the one and easiest way would and can be used easily across all the reports/visuals/pages is to add a column with rank using DESC and this will rank highest value as 1, and then page level filter you can use this rank column to say filter where value is greater than 1, so the highest number will always get filtered, to add a rank column following this blog

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: How to surpress one imported value without manual work

@NovaBI , not sure I got it. But you can create desc rank on version filter on latest version rank 1 on page or visual

 

This is what we can do with Today or Max data date

Is Today = if('Date'[Date]=TODAY(),"Today",[Date]&"")

Is amx= if('Date'[Date]=Max(Table[Date]),"Max",[Date]&"")

 

Now We can select today to the max date



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Super User VII
Super User VII

Re: How to surpress one imported value without manual work

@NovaBI the one and easiest way would and can be used easily across all the reports/visuals/pages is to add a column with rank using DESC and this will rank highest value as 1, and then page level filter you can use this rank column to say filter where value is greater than 1, so the highest number will always get filtered, to add a rank column following this blog

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Helper III
Helper III

Re: How to surpress one imported value without manual work

@parry2k thanks for that. I'd love to have something without a new column due to performance saving, but this is very good too. Thanks!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors