Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I am trying to make a chart with indicators that also are headers of a matrix. My dataset has 4 variables (Date, Indicators (A,B,C,D), Currency and Value). I have a matrix where the rows are the "Currency", the columns are the Indicators A and B and the values are "Value". In my chart, the axis is Indicators (C and D), the legend is the "Currency" and the values is "Values". I want to make this chart ignore what is selected in the matrix columns but I need it to be responsive to the matrix rows (currency). How can I do it?
I the Fig 1, we can see the screen if no filter is selected. And I want to select a currency (row) or a value in the matrix. But if I do it, my chat turns blank (FIg 2) where I want to see the values of C and D for the selected currency.
All files and data are here .
Thanks very much
Solved! Go to Solution.
hi, @felsilveira
You could use “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT.
For valor value
Measure = CALCULATE(SUM(dados[valor]),ALL(label))
Best Regards,
Lin
hi, @felsilveira
And for you select a currency (row) or a value in the matrix. But chat turns blank, please check if there is any visual/page/report level filter in the chat visual.
I find that it works well in you sample pbix file.
Best Regards,
Lin
hi, @felsilveira
You could use “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT.
For valor value
Measure = CALCULATE(SUM(dados[valor]),ALL(label))
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |