cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mal_Sondh
Helper II
Helper II

Slicing data and returning the text for the latest period

Hi,

I would like to create slicer to switch between different RAG notes, rather than having to create separate visuals from them all:

 

Data is as follows (Projects Main):

 

DateProject CodeOverall NotesBudget NotesDelivery Notes
Jan-21123No issuesBudget has no issuesDelivery is on track
Jan-21543Delivery at risk due to No UI  resourceNo Budget IssuesStill looking for a devloper to complete the UI
Jan-21999Scope increased with Budgetary concernsScope has been increased which has caused for us to now re-budgetCurrent scope deilvery on time, although at risk due to scope increase
Feb-21123No overall issuesNo issuesNo issues
Feb-21543UI person has been recruited, looking to pull back timelines on deliveryNoneUI person is now onboard and looking to pull delivery to original timelines
Feb-21999NoneNoneNone

 

I have created a static table that just lists the following (Latest Notes):

RAG Note Type:

Overall Notes

Budget Notes

Delivery Notes

 

Depending on the date selected on the top page filter, i would like to return the notes aligned to that period.

 

For instance if i had selected Jan-21 in the report filter and Project 123 then i would expect to see all Jan-21 Notes related to this project - but switchable using the slicer as shown in the attachment.

 

Screenshot 2021-07-06 at 12.21.26.png

 

I created measures for each of the notes:

Budget Notes = Calculate (Max('Projects Main'[budgetnotes]))

Delivery Notes = Calculate (Max('Projects Main'[deliverynotes]))

Overall Notes = Calculate (Max('Projects Main'[overallnotes]))

 

I then created a calculated column:

 

Slicer Selection = 

If( ISCROSSFILTERED('Latest Notes'[RAG Note Type]),

SWITCH(SELECTEDVALUE ('Latest Notes'[RAG Note Type]),

"Budget", [Budget Notes],

"Delivery", [Delivery Notes],

"Overall", [Overall Notes])

)

 

I then added the slicer selection into a field on a text visual - however it doesnt return what i expect.

Any help would be appreaciated 

1 ACCEPTED SOLUTION
Mal_Sondh
Helper II
Helper II

I have resolved it - 

 

Slicer Selection = 

If( ISCROSSFILTERED('Latest Notes'[RAG Note Type]),

SWITCH(SELECTEDVALUE ('Latest Notes'[RAG Note Type]),

"Budget Notes", [Budget Notes],

"Delivery Notes", [Delivery Notes],

"Overall Notes", [Overall Notes])

)

View solution in original post

1 REPLY 1
Mal_Sondh
Helper II
Helper II

I have resolved it - 

 

Slicer Selection = 

If( ISCROSSFILTERED('Latest Notes'[RAG Note Type]),

SWITCH(SELECTEDVALUE ('Latest Notes'[RAG Note Type]),

"Budget Notes", [Budget Notes],

"Delivery Notes", [Delivery Notes],

"Overall Notes", [Overall Notes])

)

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.