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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NJCLIFFORD
Frequent Visitor

Dashboard dynamic filter

Howdy all,

Have created a dashboard with a heap of KPI's on it.

Most are monthly, and work easy - have column chart viz and the latest colum represents the current month. ALso on each KPI have the latest months acutal value displayed also in a card visulizationCapture.JPG

 

Question 1: can you limit how many columns are shown on the vizualisation?  I am currently going in and manually selecting the last 8 months to show.

 

There are a few of the KPI's that are weekly - now to show the latest column here is what I am having trouble with.  I am currently having to go into the viz, change the columns shown (similar to above), but then also changing the filter on the actual value (with monthly one I just set to current month, not possible here).

 

Question 2: Is there any way I can get that to update the Card Viz with the latest value?

 

Thanks


Nick

1 REPLY 1
amitchandak
Super User
Super User

@NJCLIFFORD , You can use, relative date slicer, TOPN filter, TOPN measure.

 

You can use numeric parameters in TOPN

TOPN: https://youtu.be/QIVEFp-QiOk
TOPN with Numeric Parameter -https://youtu.be/cN8AO3_vmlY?t=26448

 

If that latest value of Date or time, we need measure

 

Like for date

new measure =
var _max = maxx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] =_max))

 

for month MTD will show max month, based on the selection

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.