Forum Discussion
Newbi needs help with simple bar graph
Hi All Apologies if this is a double up - I tried to post it 3 times now before but it keeps crashing. I have a data set like this: Name Total Due Dec Nov Oct Pre-Oct Customer 1 $1,019...
Hi David-CF
As tested, i can get this result finally, please download my pbix for more details.
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
Best Regards
Maggie
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help - I'll give it a try.
