Newbi needs help with simple bar graph

Hi David-CF 

Per your screenshot, if this is your raw data, do following transformation and create a bar graph.

1.  go to Edit Query - Select Customer Name Column - Use Unpivot other columns from Transform tab - Unpivot Columns

2. use Rename Attribute column if you want to

3. Close and Apply the power Query window

4. Add Bar graph visual on your report page. - attribute/renamed col in axis value column in values

5. create a tooltip page as instructed on below link.

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

this should get you what you trying to achieve, let me know in case of any questions.

Thank You,

Washivale

Hi David-CF 

As tested, i can get this result finally, please download my pbix for more details.

1.create what-if parameter

2.Create measures

Measure =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        ALLSELECTED ( 'Table' ),
        'Table'[year] = MAX ( 'Table'[year] )
            && 'Table'[month] = MAX ( 'Table'[month] )
            && 'Table'[Name] = MAX ( 'Table'[Name] )
    )
)

Measure 2 = RANKX(ALLSELECTED('Table'),[Measure],,DESC,Dense)

Measure 3 = IF([Measure 2]<=[top n Parameter Value],[Measure])

3. Create a tooltip page

4. Create tooltips based on report pages in Power BI Desktop