Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started


Create a slicer to see all data vs one part of data

Hi, I want to create a slicer to filter my data. These data are detail data set A . I extracted newest data B from them with a column isNewest flagged to `True`. I want a slicer user can select "Detail" vs "Newest" to see data set A or B( B ⊆ A).


I found if or switch in DAX is not filt this situration, because if a data goes into if sentence or first swithc case, it will not goes into second sentence.


Can you help me with this? Thanks


The format  of data which comming into PowerBI is like this:

PullRequestId, PRIteration, service result...


After adding some columns in PowerBI, the format is:

PullRequestId, PRIteration, service result... MaxIterationOfThisPR, isNewestIteration


To see our service result in powerBI page, we need to organize data by each iteration or each PR(we take the data with max iteration from that PR as the service result for that PR). So we want to add a slicer, it has two options, if user select the first option, all data will shows up; if user select the second option, it will only show the lines with isNewestIteration is "True".

Frequent Visitor

Wel, I'm facing what I thing is a similar problem, which I guess will have an easy solution, but so far I did not find it.


I put my example, Imagine I have a visual with all invoices pending of paymet made to X (no matter whether is a client or all invoices to a copuntry or agent...) and I want a filter / button to, when selected, see only the matured invoices...


So it is a case of showing everything (all data, all pending invoices) ot just a part of such everything (only the matured incoices).


We have metrics such date of maturity, number of days an invoice is matured and so on....  what I need is how to allow the user to filter between "all" and "matured"

Community Support
Community Support

Hi @fazhong ,


Please show an example of the data used by the slicer and explain what value visuals return when the slicer is selected.


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

@fazhong , Not very clear, But overlap in the same column, I doubt you can have

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

I've added some details. The file is not in my hand now. If you want more infomation, please tell me.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors