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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Dynamic measure based on a family of slicers

Hi all! 
I have a dashboard to build in which I've created a group of slicers that influence each other, let's say if I select year of 2020 and month of April it will display further or not the list of other available categories like type, sub-type etc. based on the entries that exist from the query I've been working with.  
So far, so good. 
I've tried building a dynamic calculated table based on slicer-dependent parameters in order to plot a bar-chart later-on but as much I read on the forums Power BI is limited concerning this aspect. 
So I've switched my focus on building the report based on dynamic measures but somehow I still manage to fail. 
I've tried working with Switch & a combination of HasOneFilter / HasOneValue  // nested IF statements but I got stuck. 
Need to mention that the slicer is based on group of 5 mixed columns in terms of data-types. (Text, Numerical, Date/Time) & that are linked together in that group and my desired output is to display a calculated column which is built from a combination of 3 columns from my main table that is outside my query & is of Decimal Type. 

Every little bit of help is much appreciated! Thanks & sorry for bothering you! 🙂

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , not very clear. But measure slicer refer. The last video from GuyInACube, using external tools have a lot of features to control the data format 


https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME

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
Anonymous
Not applicable

@amitchandak 
To be more specific, I'll attach a few screenshots below. 
As you can see in the first pic I a group of five slicers, from which the "Steel grade" & "Diameter" are of text type, while the first 2 are of Date type & last one of decimal. 
The column below of Values lists all the numeric entries that are based on a 3 column group from the main table. 
As you can see in the 2nd & 3rd pic, the selections are depending on each other & my challenge here is to build a measure that shows the numeric values in the column below based on the end-user selection from that filter. 
Also based on that, I want to count  & then later bin them. 
P1P1p2p2p3p3

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.