Forum Discussion
JaneSmith23
2 years agoRegular Visitor
Help - with powerBI
Hi, I'm new to PowerBi. I was curious how can I make a donut chart with data from my data set that I need to extract First is column is Courntires but I only need 5 countries selected ej ...
Anonymous
2 years agoNot applicable
Hi JaneSmith23 ,
I have created a simple sample, please refer to it to see if it helps you.
Create another date table to filter the date.
Table 2 = calendar(DATE(2021,1,1),DATE(2021,12,31))
Put the table 2[date] into the slicer.
Measure =
VAR _maxdate =
MAXX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Date] )
VAR _mindate =
MINX ( ALLSELECTED ( 'Table 2' ), 'Table 2'[Date] )
RETURN
CALCULATE (
SUM ( 'Table'[value] ),
FILTER (
ALL ( 'Table' ),
'Table'[country] = SELECTEDVALUE ( 'Table'[country] )
&& 'Table'[date] <= _maxdate
&& 'Table'[date] >= _mindate
)
)
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.