Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm struggling to get to grips with a couple of tables outputting different figures,
I have 2 tables with the same data in them but formatted differently (RFQ Final CP is formatted as text and has 2 different currencies in them and RFQCost is formatted as a decimal number), I have both value columns on separate cards, but they are outputting different numbers on the cards, why would they output differently?
Thanks,
Paul
Hi @PaulHolt ,
Maybe the Value column from RFQ Final CP has been formatted like this:
format with two currencies =
IF (
MAX ( 'RFQ Final CP'[ID] ) <= 3,
FORMAT ( SUM ( 'RFQ Final CP'[Value] ), "£#.00" ),
FORMAT ( SUM ( 'RFQ Final CP'[Value] ), "€#.00" )
)
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Eyelyn Qin
@PaulHolt without seeing a sample file, did you try clicking on the funnel icon and check that any filters applying to each card visual are the same?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
107 | |
70 | |
70 | |
43 |
User | Count |
---|---|
148 | |
104 | |
104 | |
89 | |
66 |