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.
Dear All,
I need to get a filter with the options below:
- Monthy Turnover
- Monthly Turnover vs. previous year
And the cards need to change according to the option selected - that means I have two different measures at the same card, but changing depending on the calculation selected.
How can I do that, please?
And second option...
Is it possible to have different distribution lists for different sheets?
Thank you in advance.
Solved! Go to Solution.
Hi @Anonymous
You may build a slicer Table as below and build a measure to achieve your goal : show different result if you select different options.
Slicer Table
Measure:
Measure =
Var _Sel = SELECTEDVALUE(Slicer[Option])
Var _Monthy_Turnover = 1
Var _Monthly_Turnover_vs_previous_year = 2
Return
IF(HASONEFILTER(Slicer[Option]),IF(_Sel = "Monthy Turnover",_Monthy_Turnover,_Monthly_Turnover_vs_previous_year),"")
Due to I don't know your data model and the measure you build, so in my measure I use 1 and 2 to replace your measure in var.
Result is as below. The card visual will show different result by select options in slicer.
Option = Monthly Turnover vs. previous year
Option = Monthy Turnover
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.
Best Regards,
Rico Zhou
Hi, @v-rzhou-msft
Sorry, I was on vacation. And yes, my problem is solved, but there's still an issue...
My card has two different measures, and the first one is percentage, while the second is an absolute value.
I can't format the measures according to the conditions above.
It seems the format replies the card, not the measure. What can I do, please?
Hi @Anonymous
You may build a slicer Table as below and build a measure to achieve your goal : show different result if you select different options.
Slicer Table
Measure:
Measure =
Var _Sel = SELECTEDVALUE(Slicer[Option])
Var _Monthy_Turnover = 1
Var _Monthly_Turnover_vs_previous_year = 2
Return
IF(HASONEFILTER(Slicer[Option]),IF(_Sel = "Monthy Turnover",_Monthy_Turnover,_Monthly_Turnover_vs_previous_year),"")
Due to I don't know your data model and the measure you build, so in my measure I use 1 and 2 to replace your measure in var.
Result is as below. The card visual will show different result by select options in slicer.
Option = Monthly Turnover vs. previous year
Option = Monthy Turnover
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , seem like a case of measure slicer
refer
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
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |