Forum Discussion
Need help without dax
- 9 years ago
Hello,
Thank you all of you, I am new with BI power so I make stupid mistakes and I didn't pay attention that my data are text, and I am using %, so for that reason I can't get any graph, now that works very good.
Thannnnk you
I wish that you can help me to visualize the evolution of % of my top products by a graphic,
Thank you
With date being your primary data element between the 4 products, consider a Line or Area chart at the very basic level. There's numerous other options, but I'm not sure what you %'s represent??? To go any deeper, you may need to bring in Non-Percentage values to look sales over time, or consider adding KPI (Key Performance Indicators). For example, each product needs to sell X% to be profitable? So how far over / under that profit line is the product? We can go on and on, but ask yourself "What questions get asked the most around the office, and how can I answer them with 1 Visual? (Or a grouping of visuals?)"
FOrrest
- chaima19 years agoRegular Visitor
My percentages are just like how much are my sales from the good type of the product.
The point I can get any graphics even the sample ones, I don't know why?
- fhill9 years agoResident Rockstar
I'm guessing your data still has "6 %" as a Text field. You can't graph Text data. You'll need to SPLIT the data to get just the numbers and make it a Numberic field before graphing...
Beyond this you may need to share your PBIX file for us to see what's happening.... FOrrest
- chaima19 years agoRegular Visitor
Hello,
Thank you all of you, I am new with BI power so I make stupid mistakes and I didn't pay attention that my data are text, and I am using %, so for that reason I can't get any graph, now that works very good.
Thannnnk you