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

[fazhong]

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".

[robindlc]

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"

[v-lionel-msft]

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.

[amitchandak]

@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.

[fazhong]

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