Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Could someone help why the line value function is not working with the selectedvalue in the slicer.
Have a slicer Fund Type with the options below. Using a card with DAX
Solved! Go to Solution.
Hi @Anonymous, you have Fund Type as your legend, which might be stopping your measure from evaluating as TRUE.
Hi @Anonymous
I am so glad to hear that you have solved your problem , please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Ailsa Tao
It did not work unless the column series Fund Type is remove. Found a way around it where the slicer is at the Fund Type table ( containing a list of distinct values) and the coumn series is at the table row level. Thank you so much for your help
Needed to have column series of fund type and need to calculate the average in the line depending on the fund type selected. If none is selected then it is average of all fund types. Hope that clarify the context on the goal
Hi @Anonymous, does this work?:
Avg =
IF(
CALCULATE(
DISTINCTCOUNT('Fund Type'[Fund Type])
, ALLSELECTED('Fund Type'[Fund Type])
) > 1
, 50000
, 200
)
Needed the fund type in the column series to depict the different colour of the fund type. Is there a way to based only on selected value.
Hi @Anonymous, you have Fund Type as your legend, which might be stopping your measure from evaluating as TRUE.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
7 | |
6 |
User | Count |
---|---|
14 | |
13 | |
11 | |
9 | |
8 |