Forum Discussion
Highlighting and wrap text in multirow card
Community ChampionHow long is the text in these columns???
And to channel MattAllington - I don't know if this is the best way to setup you data? (from the little I can gather)
http://exceleratorbi.com.au/shaping-modelling-power-bi/
But to answer you question yes you can use TEXT but you'll have to use a Measure to display it
As you can see you'll also need Color Columns for each so you can use them to determine the state of each card...
That's why you may have to re-shape your data
Good Luck! :smileyhappy:
What's your Problem A Measure here?
I'll answer your questions too, but I'd try this first :)
- Sean
mfaberI used this Measure for my example
Problem A Measure = IF ( HASONEVALUE ( 'Table'[Project] ), CONCATENATEX ( 'Table', 'Table'[Problem A], ",", 'Table'[Problem A], ASC ), "Select a Project" )Good Luck! :smileyhappy:
I'm getting closer, but I got stuck.. Sorry for taking so much of your time :)
So, I'm doing a report about the product placements and image of our partners in different stores. There are some free style text boxes to fill on different viewpoints that we have to check, so it's like: Product placement problem: "There are other manufacturer's products on our table". Product pricing problem: "The price tags on the aisle show different prices than the ones on the webpage", Product stock problem: "No problem occured". I just made these up, but it's something like that. These are what I called Problem A, B and C.
In my data table every single visit is a different row, and every viewpoint is a different column, that's how my data is set up.
With the multi-row card I could show this like in the pics, I posted first, but it has a static background and font color, and I find it disturbing, that it's still red, while there's no problem occured. So I just need two different cases. When the text says "No problem", I'd like it to be green, everything else is red, as there are only problems listed in these fields.
Where I got stuck with your solution is that in the PA color measure, the SWITCH formula says it requires an expression with single values as a "single value cannot be determined", when I choose the column where Problem A-s are listed. But the same problem can happen multiple times, I'm gonna have hundreds of rows of data (visits).
The slicers gonna be set to show one single visit every time, so it doesn't have to show multiple visits.
Any idea? :smileyfrustrated: