Forum Discussion
Really Frustrated with Power BI
Hello everyone,
After purchasing power bi pro we are running into unending issues. I created a report using multi row card. Iam getting the data from a direct query. The issues i am having are :
1) How can i edit the name of the Card?
2)How can i do conditional formatting. I do not see the option
3) How can i add a calculation?
Please suggest.
Thanks
HI Anonymous ,
Please forgive me but I miss lead you on my answer about the renaming of the card. You card is based on a column that as the "status" correct?
In this case you cannot change the values on the card, you need to chang it on your data itself one option is trough the query editor.
Regards,
MFelix
14 Replies
- parry2k
Super User
Anonymous
#1 - what you mean by name of the card? Are you referring "Title", you can change title by going to format pane.
#2 - on card visual, unfortunately there is no conditional formatting. may be you want to put this as an idea on idea forum.
#3 - What calculation you want to put? DAX language allows you to do complex calculations which you can then use on your card or other visuals.
Hope it is helpful, if you can provide more informatin on calculation, someone will surely able to help.
parry2k Thanks
Well conditional formatting on cards is a show stopper. Hmm.
Couple of things like i mentioned i used a direct query, i want to add calculation in that query . Is that possible ? How can i edit the sql code is there a document?
- MFelix
Hi Anonymous ,
First of all you need to understand that not all the visuals have all the options, although PBI is getting a lot of visuals with more and more options.
1) What do you mean by name of the Card?
- If you are refering to an overall title you need to activate the title and write your title
- If you refer to the Category below each value:
- On each field that you have selected double click and rename the field for whatever you need.
2) Multicard does not allow to have condittional formatting
3) Assuming that you want to have a sum of the values on the card or similar correct?
- You need to add a new measure to your card be aware that this may not result has you need in terms of visualization.
Why don't you use a matrix or table visual to do your visualization it allows customization at the conditional formatting and also make calculations based on context.
Regards,
MFelix
Thanks ,
I am not a big fan of thecards either, but the end user ( in this case our client) wants the visuals as cards
Thanks
- MFelix
Hi Anonymous ,
Your title is the "Corners" correct? You need to go to the options and change the title on the available space check my image on previous post.
Regarding the colors on the options of the multicard you cannot make it a different color, one option is to create 3 multicards with a filter on each of your categories and then change the bar colour individually.
Regards,
MFelix
