Forum Discussion
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
Australia
America
England
Ireland
Japan
Second I have a set of dates in a column but I only need to have a certain range eg 1Janurary 2020 to 31October 2020
I made a measure for the dates to pick up the dates needed but when I when to make the chart it did not like it.
If someone could help that would be amazing 🙂
2 Replies
Hi JaneSmith23
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi 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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
