Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

high light histogram chart

Hi,

i want to create new report, in report user can select target , and the report should be hightlight histogram 

as sample : if user select %5 in target , histogram data will be hight light between 95% and 105% 

how can i high light info in histogram chart, somethines like below chart

hight light works on axis chart

 

 

  • Anonymous A similiar visual can be created with combo visual:

     

     

    I created a parameter for the target then a measure to use on the visual:

     

    Target =
    IF (
        MIN ( 'Table'[Bins] ) <= ( 1 + Target[Target Value] )
            && MIN ( 'Table'[Bins] ) >= ( 1 - Target[Target Value] ),
        1,
        0
    )

2 Replies

  • DataZoe's avatar
    DataZoe
    Microsoft Employee

    Anonymous A similiar visual can be created with combo visual:

     

     

    I created a parameter for the target then a measure to use on the visual:

     

    Target =
    IF (
        MIN ( 'Table'[Bins] ) <= ( 1 + Target[Target Value] )
            && MIN ( 'Table'[Bins] ) >= ( 1 - Target[Target Value] ),
        1,
        0
    )

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for big help. 

       

      i have another issue regarding high light chart , i need to impelent same way in Matrix, i found  "dot plot by MAQ" chart to show info like below photo but there is not any liner value , do you have any clue how can i implement chart in power bi