Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Occo
Regular Visitor

Slicing data

Hi All, new to Power BI but very excited by it.

 

Curently I am trying to slice my data. I have an "economic statistic" per county (about 15) starting from 1985 to the end of Dec 2020. Ultimately I just want show a line graph where I can click off and on countries and select any time period I want. I have had no problem slicing by time.

 

dispaly.JPG

 

When I go to slice by country it doesnt work. I think my hirachy is out of order but not sure how to change. When I drop a country into the slice, it slices it by each individual "economic statistic" within the country, rather than by country (so then I can click countries on and off at will). Below is the import. Would really appreciate if someone could try and slice this by country @wdx223_Daniel .

 

Would really appreciate any assitance. Thanks!

 

DateUnited States
(Large Cap)
United States
(Small Cap)
United States
(Nasdaq)
CanadaUnited Kingdom
(Large Cap)
United Kingdom
(Mid Cap)
FranceGermanySpainItalyRussiaIndia
31/12/202033.44112.9855.3322.8213.6621.5823.8719.6415.1122.129.7329.91
30/11/202032.41104.1253.0422.2913.2020.3323.6518.9514.8921.858.9927.69
31/10/202031.2788.0448.1121.0711.7018.0919.8917.8211.7217.067.9224.91
30/09/202030.8486.4950.1521.0412.3318.2919.2519.0712.0917.738.3224.60
31/08/202030.8189.8253.7021.4212.5018.8419.5719.2312.3718.069.0824.86
31/07/202031.1185.5748.9521.1212.3418.0018.4418.0312.0317.868.8224.27
30/06/202029.3584.5146.1721.6713.2218.3119.7618.4412.3618.718.2123.29
31/05/202027.6482.8643.7821.3412.9118.3418.7517.4912.0717.628.3121.61
30/04/202026.0378.9241.5720.4112.4317.8118.4416.3511.6616.887.8922.27
31/03/202023.4269.5835.9817.8511.8516.4718.1214.7511.3515.765.7819.29
29/02/202031.0390.3139.3421.9113.7521.1921.9218.0314.4920.607.4425.14
31/01/202031.23100.1742.2423.0515.2923.3524.1819.8815.4422.258.2126.84
31/12/201930.91106.2941.6522.3315.8124.1824.6020.1915.4922.7610.0527.49
30/11/201929.91105.7040.4723.0615.4223.0824.8621.3515.0922.609.3627.34
31/10/201928.84103.5639.3122.4015.2722.3224.2020.8314.8922.199.2727.19
30/09/201929.45103.3538.2522.8715.6222.2524.0720.3014.9422.389.1326.55
31/08/201928.95103.4138.3622.6115.2221.6223.2719.8414.1821.758.8625.66
31/07/201930.31111.0839.5622.6916.1121.9623.0020.9214.3621.818.9725.99
30/06/201931.00113.2839.2023.6915.7721.7323.7120.6414.5421.209.6527.91
31/05/201927.99107.6936.8123.1915.2021.2022.3119.7114.1319.809.0028.29
30/04/201930.14118.9140.6724.1215.7622.2424.0120.9014.9621.948.7328.00
31/03/201931.08116.5639.1924.1415.5321.6323.4019.7814.5020.458.5628.00
28/02/201930.52120.6238.1423.1915.0921.8023.0619.2814.5220.588.7325.97
31/01/201930.30115.6337.6022.4714.9021.4722.4318.9414.0319.858.7026.01
31/12/201828.02105.6935.1921.3714.2920.0721.8118.2313.0417.697.8625.86
30/11/201829.02120.9239.0322.8714.8221.3223.2319.7313.7318.668.3025.90
31/10/201830.18119.9839.5222.0515.1722.0323.3220.7313.3319.008.0924.73
30/09/201831.04136.2144.0623.2116.0123.8424.7522.1714.0120.148.5026.12
31/08/201832.62139.4944.4723.5615.8524.4223.9322.6113.9119.898.1027.85
31/07/201832.84133.7342.2624.3116.6024.8824.8923.6814.5021.288.1227.16
30/06/201832.20130.8741.3824.2816.3624.9824.2222.9513.9021.457.8725.81
31/05/201831.83129.9141.3823.9416.4625.2023.9022.9813.6220.668.7925.99
30/04/201831.34122.4939.6822.8016.1424.7724.4022.7714.3921.407.8626.09
31/03/201830.97121.3940.0722.5715.2224.0322.5021.5813.8620.127.7924.62
1 ACCEPTED SOLUTION

@Occo 


Your current model is not possible to achieve the slicing. please transform your table into something like the following format, then create 2 separate slicers using Date and Country columns.

 

Date Country Value1 Value2
31/12/2020 US xx xx
30/11/2020 UK xx xx
31/10/2020 Canada xx xx
.. ... .. ..
       


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
wdx223_Daniel
Super User
Super User

your image did not show the slicer of countries, it seems you put it into the legend or aixs

 

Hi there, I didnt put any slicer on there at all. I'll do it and post it on.

 

Occo
Regular Visitor

This time I just tried to do Australia and Brazil.  The attempted county slice is below the date slice.

Thanks Daniel.

 

aus braz.JPG

 

@Occo 


Your current model is not possible to achieve the slicing. please transform your table into something like the following format, then create 2 separate slicers using Date and Country columns.

 

Date Country Value1 Value2
31/12/2020 US xx xx
30/11/2020 UK xx xx
31/10/2020 Canada xx xx
.. ... .. ..
       


Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

That did the trick. Thank you for taking the time to reply.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors