cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Highlighting using table

Hi everyone,

 

I have items with statuses, and every item could change its status over time. But when I select status in table, it selects all items which had or have this status over time. How can I select only last value? I've tried to add visual level filter, but it didn't accept date field.

 

Example of how problem looks:

item_name had statuses status_1, status_2 but currently has status_3

item_name_1 had status_1, currently has status_2

item_name_2 had status_2, currently has status_1

When I click on status_1, it selects all three item names, but I want to select only status_1.

 

Regards,

Yerkhan

4 REPLIES 4
Highlighted
Solution Sage
Solution Sage

Re: Highlighting using table

Hi @ysapiyev

 

Maybe you can uuse the Max function

If(YourDateColumn=MAX(YourDateColumn);Status)

 

Something like that

 

Else if you don't understand

Can you please provide us a sample of your data ? 

 

- Quentin

Highlighted
Responsive Resident
Responsive Resident

Re: Highlighting using table

@quentin_vigne,

 

I have live connection, therefore, I can't use DAX functions.

 

Regards, 

Yerkhan

 

Highlighted
Solution Sage
Solution Sage

Re: Highlighting using table

@ysapiyev

 

 

Did you try to use the 'Last value' filter ? There is Top-N filtering and you can filter from top or bottom. Maybe use it with your date ? 

 

- Quentin

Highlighted
Responsive Resident
Responsive Resident

Re: Highlighting using table

@quentin_vigne,

 

I've tried this, when I use top or bottom 1 by date, it shows me empty table.

 

Regarding sample data, it has many connections inside of database, I'm not sure I can correctly extract this data.

 

Regards,

Yerkhan

 

 

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