Forum Discussion
Default value selection in line Graph Power BI
Hi Team, I have a report in which there is a line graph and a bar graph. I have a catagory column Say A,B,C and the price associated with it. Now a bar graph shows all the catagories and respec...
parry2k Thanks for the reply. It worked when i use below formula :-
Default Measure =IF(COUNTROWS(DISTINCT(ALLSELECTED(Sales[Catagory]))) < COUNTROWS(DISTINCT(ALL(Sales[Catagory]))) , SUM(Sales[Profit]),IF(SELECTEDVALUE(Sales[Catagory]) = "B",SUM(Sales[Profit]), BLANK()))
Anonymous sure you can do something like this
Line Measure =
VAR __selectedCategory = SELECTEDVALUE ( Table[Category], "B" )
RETURN
CALCULATE ( SUM ( Table[Column] ), Table[Category] = __selectedCategory )
if this doesn't work then share sample data.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
parry2k Thanks for the reply. It worked when i use below formula :-
Default Measure =
IF(COUNTROWS(DISTINCT(ALLSELECTED(Sales[Catagory]))) < COUNTROWS(DISTINCT(ALL(Sales[Catagory]))) , SUM(Sales[Profit])
,
IF(SELECTEDVALUE(Sales[Catagory]) = "B",SUM(Sales[Profit]), BLANK()))
Anonymous great if it worked out, accept it as a solution so that others can benefit from the solution.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!