Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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()))
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

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!