March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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! 🙂
@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
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
84 | |
70 | |
51 |
User | Count |
---|---|
206 | |
143 | |
97 | |
79 | |
68 |