Forum Discussion

Grant82's avatar
Grant82
Frequent Visitor
3 years ago
Solved

Help on slicing by column name

Hi guys, I'm pretty new to Power BI (I downloaded it for the first time a few weeks ago and have been on youtube since) and I've built a solution and dashboard for an email campaign. Most of it seems...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Grant82 

    According to your description, you want to " be able to show a theme's monthly line data correctly, and slice by theme which is a column name".

    For your raw data , this data format is useless for analysis in Power BI, you can use RawData2 directly.

    Here are the steps you can refer to :
    (1)This is my test data , i have only one table like your Raw Data2:

    (2)We just need to put this fields on the visual and we can see the "Attribute" we selected in the slicer :

     

    If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem. (You can also upload you sample .pbix [without sensitive data] to the OneDrive and share with the OneDrive link to me ! )

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , Grant82 

Thanks for your reply , you can try to click "New Column" create a calcualted column  in Power BI Desktop :

Column = MID([Attribute],SEARCH( "-" , [Attribute])+2 , LEN([Attribute])-SEARCH( "-" , [Attribute]))

Then you can use this new column as the field.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Grant82's avatar
Grant82
Frequent Visitor
3 years ago

That's awesome thank you! One more - I'm almost there - is there any way to increase the area that the columns use so that they're not just tightly clustered in the middle of the graph?

 

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , Grant82 

    This is the default behavior for placing a Legend, and will display your bar chart in-display, and cannot change the surrounding width.

    If you want to display the Attribute value of a certain month and display it in a scattered manner, then you cannot place the Attribute on the Legend, but only on the X axis:

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly