Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Below is the measure that I am using in the Stack column chart.
Last 6 month Order = CALCULATE ( COUNT( Fact_Table[Order_Id] ), DATESINPERIOD ( 'Date Dimension'[Date], ENDOFMONTH( 'Date Dimension'[Date] ), -6, MONTH)).
Month Year = CONCATENATE(Upper(Fact_Table[Related Month]),CONCATENATE(" ",right(Fact_Table[Year],2)))
Which are working fine.
In addition to that I need to show % of total order for each section in a bar in the Tooltip.
I am struggling with the DAX calculation for Percentage.
Is it possible to display Percentage value in the Tooltip?
I am not able to add the filter in my DAX correctly for the "Level" to get the percentage of total column value.
Thanks In Advance
Solved! Go to Solution.
@Anonymous
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040
Have you tried to put your % measure on Tooltip. Of percent measure calculation has problem
Hi @amitchandak
No I am struggling with the DAX. Not getting the correct Filter () with ALL/ALLEXCEPT/ALLSELECTED.
@Anonymous
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |