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.
I’m using the table bellow as dinamics rates for the year.
And my BI chooses what row it should use, depending on the vessel (Sonda) and year(Ano).
I would like to know, is how can I create a way to choose the rows UNP, when I select the years (ANO) 2018 or 2019 and the slicer Year (ANO) with the option every (All options filtered) ?
Hi @veronicarocha ,
I am not sure what desired result would you want, could you please share your sample data and desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.
Please read this post to get your answer quickly: How to Get Your Question Answered Quickly.
Best Regards,
Amy
Below is the link with the files,
https://drive.google.com/drive/folders/1x7ynFAD582b-CW1h3TPFJHF2sDrrGR1d?usp=sharing
I would like to use a specifc value on my chart, when my slice is set with every and a year, as bellow.
In the imagem above, is being shown 19.5 that is sum of values contained in the year of 2018, In this case, i would like to show 1.9 instead.
Hi @veronicarocha ,
You may create measure like DAX below.
Measure1 = CALCULATE(MAX(Metas[TFSA]),FILTER(ALLSELECTED(Metas),Metas[SONDA]="UNP"))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |